• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

Backup to another server

It so happens that another server on the domain has plenty of hard drive space. Is it possible to backup a database to a different server's LUN?

What kind of permissions are required for this to be set up?

1 Solution

backup database dbname
to disk = '\\servername\c$\backup.bak'

the accounts that run the sql server service and sql agent will need access to the server and perms to put files there.
Create a specifc Domain User Account dedicated for this task. this user should be in the local admin group of both machines;
Backup your databases into a directory located on the same server using SQL Server.
Then share this location with full permissions (Share and Network) ONLY to the Domain user created above. Schedule a Windows task using the robocopy.exe utility (provided by windows) to copy your backup.
SQL server is network failure intolerent, meaning that if during the backup,there any can of network failure or disconnection, your backup will fail for sure.Robocopy allow you to restart you copy in any kind of failure, there command switches that allow you to configure at which frequency to restart your backup if there any issue.
I would suggest you to process this way; I do such backups everyday on multiples servers,and it has always worked like that for me. I first tried using the SQL server itself, but too much failure...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now