LS - Recover a standby database - deleted standby file (.tuf file)

Question

 

Hi,

 

The standby file (.tuf file) got deleted accidentally on the secondary. How can I recover the database without the standby file?

Answer 1

I think you can try this way to bring the secondary database online,

Code Block

Restore database DBName with Recovery

- Deepak

Answer 2

nope it doesn't work. This will still look for the tuf file

 

Answer 3

Pls 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

- Deepak