SQL Server 2008备份错误-操作系统错误5(未能为此错误检索文本.原因:15105) [英] SQL server 2008 backup error - Operating system error 5(failed to retrieve text for this error. Reason: 15105)

问题描述

任何人都可以帮助我，我正在尝试备份位于localhost \ SQLEXPRESS上的数据库，但是我不断收到以下错误:

Can anyone help me, I'm trying to backup a 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 anyone explain what I'm doing wrong here ??

谢谢

推荐答案

SQL Server似乎无权访问文件C:\ backup.bak.我将检查分配给SQL Server服务帐户的帐户的权限.

It looks like the SQL Server doesn't have permission to access file C:\backup.bak. I would check the permissions of the account that is assigned to the SQL Server service account.

作为解决方案的一部分，您可能需要将备份文件保存到C:驱动器根目录以外的其他位置.这可能是您遇到权限问题的原因之一.

As part of the solution, you may want to save your backup files to somewhere other that the root of the C: drive. That might be one reason why you are having permission problems.

这篇关于SQL Server 2008备份错误-操作系统错误5(未能为此错误检索文本.原因:15105)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！