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?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.