Remote backup location

• Francis Lledo

  SSC Enthusiast

  Points: 114

  More actions

  July 28, 2004 at 3:59 am

  #109013

  Hi,

  How can i setup a backup location different from the local server?

  thanks

• Rajeev Lahoty

  SSC Veteran

  Points: 289

  More actions

  July 28, 2004 at 7:31 am

  #516564

  You just use UNC path as follows:

  BACKUP DATABASE Northwind TO DISK = '\\remote_server\remote_dir\Northwind.BAK'

  HTH

  -Rajeev Lahoty