SQL backup Error number: -1073548784

[guest]

We are running SQL 2005 in Windows 2008 R2. I create a backup job as shown below.

BACKUP DATABASE [PEOLive] TO DISK = N'\\10.0.0.6\register\246' WITH NOFORMAT, INIT, NAME = N'PEOLive_backup_20111003163958', SKIP, REWIND, NOUNLOAD, STATS = 10. However, th ebackup doesn't work with this Error number: -1073548784. Executing the query "BACKUP DATABASE [PEOLive] TO DISK = N'\\\\10.0.0.6\\register\\246' WITH NOFORMAT, INIT, NAME = N'PEOLive_backup_20111001000004', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Cannot open backup device '\\\\10.0.0.6\\register\\246'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I can copy files to \\10.0.0.6\register\246' and I am login using domain administrator account. What could be the problem?


--------------------------------------------------------------------------------

[guest]

In SQL Server, we can backup a database to a shared file using the script:



BACKUP DATABASE [PEOLive] TO DISK = N'\\\\10.0.0.6\\register\\246' WITH NOFORMAT, INIT, NAME = N'PEOLive_backup_20111001000004', SKIP, REWIND, NOUNLOAD, STATS = 10"



When the maintenance plan execute it, it uses the SQL Server Services account but not the logon account. So would you please have a try to resolve the issue following the steps below?



· Please help check if the SQL Server services account has sufficient permission on the file: \\10.0.0.6\register\246. If it hasn’t, please assign the write permission for it.

· Have a try to execute the maintenance plan again.



If the issue persists after above try, would you please help collect the following information?



SQL Server 2005 Error Log:

· Locate the SQL Server 2005 installation folder. For example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Log

· Under above location, compress SQL Server 2005 error logs ERRORLOG and ERRORLOG.1~6 (overall is 7 files), then upload to me through below workspace.

Note: You can find the Log folder according to your installation location.



Error Screenshot:

· When an error occurs, press PrintScreen (PrScrn) to capture a screenshot

· From Start, click Run, enter MSPAINT in the Open box, and then click OK

· Use Ctrl + V to paste the screen shot to the canvas

· From the File menu, go to Save and save as a JPG file

· Upload it to me

[guest]

You may be right and it sounds like permission issue. However, I can't make it work. I have added everyone, network services (that is SQL service account) and guest to the shared folder. Still get the same error. I have upload teh error logs and screenshot.

[guest]

I have received the files you uploaded and found the error message below:

Error: 18204, Severity: 16, State: 1. BackupDiskFile::CreateMedia: Backup device '\\10.0.0.6\register\1357' failed to create. Operating system error 5(Access is denied.).

Error: 3041, Severity: 16, State: 1. BACKUP failed to complete the command BACKUP DATABASE PEOLive. Check the backup application log for detailed messages.



I have had a research with the error message. Based on the research, it is probably caused by insufficient permission. Could you please change the SQL Service start account to another account which has sufficient permission to the folder :’\\10.0.0.6\register\1357’and then have another try to see if the issue still persists? If it still persists, please help check if the SQL Agent service account also sufficient permission on that file.

[guest]

I changed both SQL Server and Agent service account from Network services to administrator. Then restart the services, but still get the same problem. Note: both SQL and remote servers are using the same password for administrator and I can copy file to the remote server folder 1357.
--------------------------------------------------------------------------------

[guest]

Now please follow the steps below.



l Firstly we need ensure that the SQL agent startup account has sufficient permissions on \\10.0.0.6\register\246 Please change it to domain account which is a local administrator and has been assigned sysadmin role in SQL. The last but not the least, it must have sufficient permissions on the shared folder.


l I would suggest that we have a try to make a backup of the database using GUI and see whether it will succeed.

[guest]

If this is not domain network, make sure SQL service account and remote computer shared folder account using the same local administrator and same password.

[blin]

Or try to use Create a backup file for every database instead of Back up database cross one or more files