Questions about SQL backups to other servers

Backup | server | issues

A problem occurred during the implementation of the backup process due to the need to back up the database to the backup server.

such as the native SQL Server is: 10.101.38.135.

Need to back up to 10.101.38.139\d$\tempdb

The computer can directly access \\10.101.38.139\d$\tempdb to read and write;

However, when you use the SQL database backup plan, you cannot connect to this device.

According to the relevant information should be a matter of authority. The following report occurs in the log:

Event Type: Error
Event Source: MSSQLServer
Event Type: (2)
Event id:17055
Date: 2006-4-21
Event: 10:13:01
User: NT Authority\System
Computer: Lajiao
Describe:
18204:
Backupdiskfile::createmedia: Backup Device "\\10.101.38.139\d$\tempdb\pubs_db_200604211013.BAK" Create failed. Operating system error = 5 (Access denied.) )。

The final summary should be the issue of permissions caused. !!!

Later, we found the source of the problem.
In order to back up data to a remote system, you must install SQL Server to run it under an account other than "LocalSystem". The "LocalSystem" account does not have access to the remote system and the backup will fail.
The modifications are-control Panel-management tools-services. Find the MSSQLServer service, right-click the service, open the Properties window, click on the "Login" bookmark, change the login account from the Local System account to the account you set up, and then back up the remote backup.

Sometimes the problem is so simple. But the more you have to bother!