How to recover a suspect database which is in standby mode(restoring Database)
Hi all Actually I configured Log shipping to one of my database. i configured secondary database as standby with disconnect users while
restoring.It all working fine When I restared my server on daily basis. Suddenly my Secondary database **firstly it went into to standby/restoring State then now it is showing **suspect/standby**** I Am trying to recover the database it did'nt worked because it is restored state as we cannot alter database. and what is solution I can for Do that????? thanks in Advance ![alt text] : /storage/temp/2046-capture.png
Drop the suspect secondary database, restore a new copy of it and restart logshipping. No point in recovering it since it's the secondary. Though you should check the logs or I/O subsystem for reasons that could make your database suspect. But you write "When I restarted my server on daily basis", are you restarting your server on a daily basis? If so, why?