Monday, November 19, 2007 11:42 PM
The standby file (.tuf file) got deleted accidentally on the secondary. How can I recover the database without the standby file?
Tuesday, November 20, 2007 12:44 AMModeratorI think you can try this way to bring the secondary database online,
Restore database DBName with Recovery
Thursday, November 22, 2007 8:26 AMnope it doesn't work. This will still look for the tuf file
Thursday, November 22, 2007 9:25 AMModeratorPls check the last tran log backup that was restored in the secondary server. Try to restore the subsequent tran log backup in the secondary server using With Recovery option to bring the secondary database online.
Restore log DBName from disk='Tran log backup name.trn' with Recovery