Automatic database backup

• pallavi.unde

  SSCommitted

  Points: 1987

  More actions

  March 13, 2012 at 4:49 am

  #252439

  Hello,

  I am using MSSQL R2 2008 .

  I migrate my data on remote pc, and that remote server is at another city, i need to take a back up in every week once i need that backup on my local pc automatically at given time. what setting i have to do for that.??

  How could i generate backup automatically at given time??

  I tried it but storeprocedure is not running :doze:

  Thanks & Regards,
  Pallavi

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 13, 2012 at 5:02 am

  #1458387

  Use a maintenance plan, a custom backup script or Ola Hallengren's backup solution and schedule the backup with SQL Server Agent.

  You will also have to schedule a file transfer task from the remote server to your pc (or the other way round, depending on your network topology).

  Hope this helps

  Gianluca

  -- Gianluca Sartori