question

Leo avatar image
Leo asked

Changing Database Standby Mode to Normal

Hi, Is that anyway can I change one of my Log Shipping Databsse (currently Stand By / Read only) to Normal Database State without restoring log again (by selecting Restore With Recovery option)? Thanks.
sql-server-2008sqllog-shipping
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.

2 Answers

·
Tim avatar image
Tim answered
Yes, just RESTORE DATABASE DB_NAME WITH RECOVERY You don't have to actually restore a log to get the database out of standby / read only.
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.

Hemant avatar image
Hemant answered
Execute following script - Restore database database_name with recovery GO It should bring your database to normal mode without restoring log file again.
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.

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.