Sign in
Microsoft.com
 
SQL Server TechCenter
 
 
 
SQL Server TechCenter > SQL Server Forums > SQL Server Disaster Recovery and Availability > Log Shipping - Restore Procedure for 1 of 2 Secondary Servers
Ask a questionAsk a question
Search Forums:
 

AnswerLog Shipping - Restore Procedure for 1 of 2 Secondary Servers

  • Friday, November 06, 2009 6:28 PMKathyGibson96 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    We have SQL Server 2005 running on 3 boxes.  1 box (A) contains the primary database and we're log shipping that to both development and producition.

    Recently I had to stop log shipping on the development server so that I could rebuild it.  I requested last night's backup from the primary server and have it in hand.  The next transaction log backup is set for 5:00pm est today.

    Question:  When I restore the backup from the primary to the development database (which was rebuilt), do I also have to restore it to the production DB (which is just humming along fine) and was never touched.

    I know I have to restore with STANDBY, and I have a script to do that.  I just am not clear about whether I need to also restore to the production box.  I've been told I need to.

    Thx very much.
     

Answers

All Replies