How to back up an MS SQL 2008 db to a network share?

Posted on 2011-10-05
Last Modified: 2012-06-21
I'm trying to back up an MS SQL 2008 database to a network share using SQL Server Management Console.  Going to Tasks/Back Up and then attempting to add a destination, the only choices I have are local drives.  The share I want to back up to is mapped to Z:\ but Z:\ does not appear as a possible destination.  There's no place for an UNC path either.

Maybe this has something to do with the account the MS SQL Server service logs in with?

 I've tried several different built-in and regular user accounts, restarting the service each time but the only choices I have are still just local drives.
Question by:WhamMcC
    LVL 19

    Expert Comment


    Follow :
     Backing Up to a File on a Network Share
     Specifying a Universal Naming Convention (UNC) Name
    LVL 3

    Expert Comment

    You can do it from a query window

    TO DISK = '\\BackupSystem\BackupDisk1\backups\<Your_DB>.Bak';

    LVL 21

    Accepted Solution

    You can type a UNC directly into the Destination / Add popup window (i.e., don't browse).  BUT, usually your as you mentioned your sql server account won't have network permissions.  It probably runs under a local account.  To access network stuff it needs to be a domain account or a network service account.  If you change the account to have network permissions, you might consider the security implications or discuss them with somebody first.

    Author Closing Comment

    Thanks so much.  Turns out to be a simple but frustrating problem.  i.e. Don't browse.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    730 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

    15 Experts available now in Live!

    Get 1:1 Help Now