SQL Server 2008 Backup Error - Operating System Error 5 (Failed to get text for this error Cause: 15105)

Question

Can someone help me, I'm trying to backup the database located on localhost \ SQLEXPRESS, but I keep getting the following error:

Backup failed for Server 'localhost\SqlExpress'. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476 ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Cannot open backup device 'C:\backup.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105). (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&LinkId=20476 

Can someone explain what I'm doing wrong here?

thank

Answer 1

It appears that SQL Server does not have permission to access the C: \ backup.bak file. I would check the permissions of the account that is assigned to the SQL Server service account.

As part of the solution, you can save your backup files to a different location where the root of the C: drive is located. This may be one of the reasons you have permission issues.

Answer 2

I encountered this error when there was no free space for creating a backup.

Answer 3

Assuming the * .bak file is on the same computer as the instance of SQL Express, this could be an access issue.

If you download procmon http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx , you can filter this path to the file, look for ACCESS_DENIED errors and, if there are any, you can see the account name that is not can access.

Answer 4

I also got this error.

The problem was simply that I had to manually create a complete directory structure for the location of the MDF and LDF file files.

Shame on SQL Server for incorrectly reporting a missing directory!

Answer 5

I have the same error. I tried to install this by setting a higher resolution for the account using the SQL Client service, however this did not help. The problem was that I only run MS Sql Management studio in my account. So, next time ... make sure you use it as Run as administrator if you are using Win7 with UAC enabled.

Answer 6

Yes, this is a security issue. Verify the folder permissions and the service account that runs SQL Server 2008.

Answer 7

I had this error. Nothing worked for me until I ran the SQLServer log file in the MSSQL10_50 log folder. This clearly indicates which file cannot be overwritten. It turned out that the .mdf file is being written to the MSSQL10 data folder. I made sure that the folder has the same SQLServer user rights as the equivalent MSSQL10_50 folder. Then everything worked.

The problem here is that the error detail is logged but not reported, so check the logs.