Back-Up Plan

• nkm129

  SSCommitted

  Points: 1763

  More actions

  April 24, 2008 at 8:31 am

  #380149

  Hi,

  Could someone help me

  Senario :-

  1) DB Name :- Test

  2) Full Backup :- Every Sunday

  3) Diff Back Up :- Mon-Sat

  I want to restore all these on secondary server with same DB Name.

  So I have taken Sunday Backup and restore on seconday server with test name ..

  Now at monday morning I have DB Test on both server...

  At monday night I applied Diff Back up to Test DB On primary server and these changes I want to restore on seconday server...

  How can I now apply this Diff Back up on Secondary Server...

  My DB on secondary server is on Read Write mode as I applied restore fulluy option when I restore first time AS i need to use this DB for some other purpose.. So Now as DB is already in fully recover mode how to apply remaining Diff back up...

  Plaese let me know step by step procedure..

  Thanks in advance

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736129

  More actions

  April 24, 2008 at 8:38 am

  #806626

  Restore the Sunday backup with norecovery, then restore the Mon diff.