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


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.
Who is Participating?
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.
GoldenBearAuthor Commented:
Thanks! That should work. I'll have to reconfigure the SQL server agent for a domain account.
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.

All Courses

From novice to tech pro — start learning today.