Backup and recovery for the accidental DBA

• subhajeetsur

  SSC-Addicted

  Points: 453

  More actions

  May 22, 2013 at 11:27 pm

  #1617683

  yes if ur upgrading from SQL Server2005 to SQL server 2008 or SQL server 2008R2

  Below is some links which can be of help:

  http://www.scalabilityexperts.com/tools/downloads.html

  http://msdn.microsoft.com/en-us/library/ms144256.aspx

  http://msdn.microsoft.com/en-us/library/cc879337.aspx

• dbursey

  SSC Eights!

  Points: 831

  More actions

  May 24, 2013 at 5:13 am

  #1618179

  subhajeetsur (5/22/2013)

  ---

  yes if ur upgrading from SQL Server2005 to SQL server 2008 or SQL server 2008R2

  Below is some links which can be of help:

  http://www.scalabilityexperts.com/tools/downloads.html

  http://msdn.microsoft.com/en-us/library/ms144256.aspx

  http://msdn.microsoft.com/en-us/library/cc879337.aspx

  Thanks very much!

• Jeff Moden

  SSC Guru

  Points: 1004318

  More actions

  May 24, 2013 at 3:29 pm

  #1618455

  raadee (5/20/2013)

  ---

  Not sure if I replied on your post Jeff.

  It was meant for the creator of the thread.

  Ok... if the creator of the thread has databases like mine, that method will take hours. 🙂

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• raadee

  SSC Eights!

  Points: 881

  More actions

  May 27, 2013 at 4:09 am

  #1618730

  From the first post:

  " So...the next step is to create a backup of the db on server b and restore a copy on server a which will run as a scheduled job every night"

  Based on that info i suggested the ssis/copy/restore full-diff method.

  I do understand that it would not have been the proper solution if the database was very large or the timeframe was restricted.