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

Posted on 2010-01-02
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

    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

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now