Backup or restore SQL Server database to another server.

Source: Internet
Author: User
When you try to backup or restore your database to another network server in the SQL Server Enterprise Manager, you will get following error:

Cannot open backup device "\ networkserver \ C $ \ XX. Bak". device error or device off-line. See the SQL Server Error Log for more details.
Backup database is terminating abnormally.

How cocould it have happened? The reason is the MSSQLServer service is running under the LocalSystem account, and the LocalSystem account have no access to the network server as it isn' t an authenticated network account. so if you want to dump the database onto another server or a UNC path, you can change the account the MSSQLServer service runs under to an account with the relevant network rights.

Remember to restart the MSSQLServer service to make your change takes effect.
Hope this helps

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.