Transaction log restore (LOG SHIPPING)

• LAravind

  Old Hand

  Points: 387

  More actions

  October 18, 2007 at 2:23 am

  #122038

  Hi

  We have a database on sqlserver 2005 on a schedule for transaction log backups is in place already which is happening at interval of 30mins.All these transaction logs are appended to file called 'BKP' on E drive of our server. Now i have to configure logshipping for this database.Normally logshipping process will backup the transaction log,stores it in a shared folder on primary server and then copies the backupfile to another folder on secondary server and then restored ..plz correct me till now if im wrong.Now let us say our normal trans log backup schedule is as follows

  T1 at 9.30am

  T2 at 10.00am

  T3 at 10.30am

  T4 at 11.00 am

  Now i decided to schedule the log shipping transaction log backup interval once in 30mins and start transaction log backup at following intervals

  T11 AT 9.45am

  T22 AT 10.15AM

  T33 at 10.45AM

  T44 AT 11.15AM

  So T11,T22 etc these backups are restored on standby server sequentially.

  Now if Primary database goes down at 11.25am , then do i have to restore the Tlogs T1,T2,T3,T4 and make the Primary database up or i should restore T1,T11,T2,T22,T3,T33,T4,T44 for making my primary database UP..

  Regards

  Arvind L

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 18, 2007 at 2:58 am

  #743035

  Please don't post the same question more than once. Answered here:

  http://www.sqlservercentral.com/Forums/Topic412090-149-1.aspx