Small white don't know much about, details as follows, how to return a responsibility? How to solve this problem?

- an incremental backup
- open or
The EXEC sp_configure 'show advanced options, 1;
RECONFIGURE.
The EXEC sp_configure 'or', 1;
RECONFIGURE.

DECLARE @ SQL VARCHAR (500)
SELECT @ SQL='\ \ 192.168.1.200 \ dbbak \ AES - DB \ AES_omedb' + '_FULL_'
+ the CONVERT (VARCHAR (10), GETDATE (), 112)
+ 'bak'

The EXEC master.. Arbitrary 'net use \ \ 192.168.1.200 \ dbbak \ AES - 123456 DB \ AES/user: 192.168.1.200 \ dbbak'
BACKUP the DATABASE omedb TO DISK=@ SQL


The Configuration option "show advanced options" changed from 1 to 1. Run the RECONFIGURE the statement to the
The Configuration option 'or' changed from 1 to 1. Run the RECONFIGURE the statement to the
Msg 15121, Level 16, 21, the State Procedure effectively, the Line 1
An error occurred during the execution of arbitrary. A call to 'CreateProcess failed with the error code:' 5 '.
Msg 3201, Level 16, State 1, Line 14
Always open a backup device '\ \ 192.168.1.200 \ kf2b \ AES - DB \ AES_omedb_FULL_20210329 bak'. Operating system error 5 (access denied,).
Msg 3013, Level 16, State 1, Line 14
BACKUP the DATABASE is terminating abnormally.

CodePudding user response:

What is your SQL SERVER service account login and set to "local system account login, and then try again,

CodePudding user response:

Backup used in 192.168.1.199 sa account, to 1.200

CodePudding user response:

refer to the second floor weixin_45456123 response:

used in 192.168.1.199 sa account for backup to 1.200

I mean the SQL SERVER service

CodePudding user response:

The SQL server is less annoying in English, I look at the SQL server configuration manager in the SQL server services under the SQL server (mssqlserver) log on as the local system account is the localsystem should mean, look at the properties of selected is built - in the account, local system there are two options are the local service and network service