Restoring a backup of database as a scheduled job

• suri1984

  SSC-Addicted

  Points: 463

  More actions

  September 19, 2008 at 12:59 pm

  #75322

  Hi,

  1) I have a job scheduled which takes a backup of database.

  2) how do i schedule a job in another server to restore the backup of the step 1.

  Thanks

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 20, 2008 at 12:13 pm

  #874623

  Use the restore query and put it in a job or run directly from Query Analyzer..

  RESTORE DATABASE [DBNAME] FROM DISK='\\....'

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga