Due to the need to back up the database backup to the backup server, there is a problem in the implementation of the backup process.
If the SQL server is: 10.101.38.135.
Need to back up to 10.101.38.139/d $/Tempdb
Computers can directly access //10.101.38.139/d $/Tempdb to read and write;
But when using the SQL database backup plan, this device cannot be connected.
According to the relevant information, it should be permission issues. The following report happened 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 Description: 18204: BackupDiskFile :: CreateMedia: Backup device "//10.101.38.139/d $/tempdb/pubs_db_200604211013.bak "create failed. Operating system error = 5 (reject access.).
The final summary should be caused by permission. ! ! !
Later, query information, found the root of the problem In order to back up the data to the remote system, you must install SQL Server to run it under other accounts other than "Localsystem". The "localsystem" account does not have the right to access the remote system, and the backup will fail. The modified place is - Control Panel - Management Tools - Services. Find the MSSQL Server service, right-click change service, open the property window, click the "Login" bookmark, change the login account by the local system account into your account; then backup to achieve remote backup
Sometimes the problem is so simple. But more expensive!
