devxlogo

How to Backup an SQL Server Database in a Shared Network Location

Why Trust Us

If you’re running SQL Server under the Local System account, it will not have rights to backup the database on a network share. You’ll need to change the SQL Server account to perform such a backup.

Here’s the procedure:

  1. Stop the SQL service.
  2. Go to Start?>Run?>services.msc select MSSQLSERVER. Right click to choose ‘Properties.’
  3. In the tabbed pane, choose ‘LogOn.’
  4. Select ‘This account.’

    5. Provide an account that has rights to access the shared network.

  5. Click ‘OK.’

Restart SQL Server, and you will now be able to perform backups to any network share to which the account has sufficient permissions.

Disclosure
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More