Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: SQL
Expertise: Intermediate
Nov 29, 2006



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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

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.

  6. 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.

Jaya Nehru Kumar
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date