How to backup SQL Server 2008 database from VPS to local PC?

Posted on 2010-01-02
Medium Priority
Last Modified: 2012-05-08

How can I backup my VPS's SQL Server 2008 database to my local PC?

I know how to do it indirectly by using SSMS to backup to the VPS, and then using email to send myself the backup file. But I was wondering if there was something less convoluted.
Question by:GoldenBear
LVL 13

Accepted Solution

MikeWalsh earned 2000 total points
ID: 26162253
If your SQL Server Service account that runs the SQL process is a domain account and has permissions to a file share you could map a drive and backup to that or backup to a UNC path.

You could get "fancy" and include a post backup step to run a dos batch file to move the backup across the network also.

Author Closing Comment

ID: 31671966
Thanks! That should work. I'll have to reconfigure the SQL server agent for a domain account.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
"Any files you do not have backed up in at least two [other] places are files you do not care about."
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question