question

UnishSQL avatar image
UnishSQL asked

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][1] [1]: /storage/temp/2046-capture.png
sql-server-2008log-shippingsqlserver 2008r2suspectstandby
capture.png (3.8 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
raadee avatar image
raadee answered
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?
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee avatar image raadee commented ·
Well it is hard to say exactly since your laptop/workstation isn't the most reliable system to have a log shipping config on. Just restore the database and reinitialize the log shipping is it goes broke and does not magically fix itself.
1 Like 1 ·
UnishSQL avatar image UnishSQL commented ·
my server its not production server it is in my Local System..i shut Down My system after i logout
0 Likes 0 ·
UnishSQL avatar image UnishSQL commented ·
i dont know what Happened Now It Working Fine Now and I didn't Do anything @raadee
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.