Backup Local Database to a Linked Server

• Marv_SQL

  SSCommitted

  Points: 1612

  More actions

  February 3, 2016 at 1:55 pm

  #304260

  Hi all,

  I would like to backup a database to a linked server as a disaster recovery plan. I tried doing a backup and providing a folder on the linked server's c drive, but it failed. Any ideas on how I can achieve?

• JeremyE

  SSCoach

  Points: 16280

  More actions

  February 3, 2016 at 2:19 pm

  #1856414

  You would need to share the folder on the linked server and grant either the SQL Server service account (if running the backup through SSMS) or the SQL Agent service account (if running as a job) write permissions to the shared folder. Those service accounts would be on the server running the backup not the linked server service accounts. Then you can run something like below.

  BACKUP DATABASE dbname TO DISK='\\linkedserver\backupfolder\dbname.bak'