Post reply

Backup Local Database to a Linked Server

  • 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?

  • 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'

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply