What are the challenges you face when working across database platforms? Take the survey

Put database in standby mode again

JanPootJanPoot Posts: 5
edited April 12, 2007 6:46AM in SQL Backup Previous Versions
After detaching and attaching a log shipped database, is there a way to put the database in standby mode again? So the new log files can be restored.


  • Options
    Hi Jan,

    You might get away with doing a BACKUP using the NORECOVERY option followed by a RESTORE WITH STANDBY - this is not supported in the GUI itself however you can copy the script and run it it SSMS/QA adding NORECOVERY to the script.

    If this does not put the database back into a state where logs can be restored to it then you would need to do a full backup of the source database and restore that to the destination database using STANDBY.

    It really depends on what SQL Server thinks has happened to the database since it was detached/attached as to wheter it will let you do option 1. Option 2 will ofcourse work regardless of the state of the destination database.


    - James
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
Sign In or Register to comment.