SQL backup Error number: -1073548784

[blin]

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?


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

[blin]

From your description, I know that we have SQL Server 2005 installed in the Windows 2008 R2 and the backup job of our maintenance plan failed with the following error message:

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.

If I misunderstand, please feel free to let me know.



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.

[blin]

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.

[blin]

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.

[blin]

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.
--------------------------------------------------------------------------------

[blin]

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.

[blin]

Problem:

=========

we have SQL Server 2005 installed in the Windows 2008 R2 and the backup job of our maintenance plan failed with the following error message:



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.



Resolution:

=========

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



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

[blin]

I fix this problem by switch from "Back up database cross one or more files" to "Create a backup file for every database".