Home / server / Questions / 368617
Accepted
Jacob
Asked: 2012-03-12 12:59:23 +0800 CST

Backup SQL Server over Network share

  • 772

I have a SQL 08 Standard box that I would like to use a Maintenance Plan to backup a database over a network share? Is this possible as the GUI won't let me do that? It tells me it can't find the path. The SQL service has permissions to write on the share.

backup network-share sql-server-2008

1 Answers

  1. Best Answer

    This is usually because the SQL server is running under an account that does not have permission to access the network shares.

    If your SQL server account is not running under a "real" AD account, this might be the time to set that up. It's simple enough to do:

    1. Create an account for your SQL Server to run under (Feel free to make the password long and complex, you only need it once).
    2. Go to the Services control panel for that server
    3. Right-click on the SQL Services (you should do the SQL Server and the Agent), go to Properties, Log On

    4. Select "This Account" and enter the credentials for your SQL Server

      enter image description here

    5. Restart the service

    (May I suggest you test this first before shutting down a live SQL server)

    Then you can specify share permissions on the network folder to state that the SQL Server account has full read/write access, but others might only have read access, or perhaps no access at all.

    • 5