blocks|key|1310200|text|假设*.bak文件与SQL+Express实例在同一台计算机上，则可能存在权限问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1310201|如果您下载procmon+http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx，您可以根据文件路径进行过滤，查找ACCESS_DENIED错误，如果有错误，您可以看到get访问失败帐户名。|offset|length|1310202|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx^0|0|D|1P|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Assuming that the *.bak file is on the same machine as the SQL Express instance it might be a permissions issue.

If you download procmon <a href="http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx" rel="noreferrer">http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx</a> you can filter on that file path, look for ACCESS_DENIED errors and if any are there you can see the account name that's failing get to access.

blocks|key|1310234|text|看起来SQL+Server没有访问文件C:\backup.bak的权限。我将检查分配给SQL+Server服务帐户的帐户的权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1310235|作为解决方案的一部分，您可能希望将备份文件保存到C:盘根目录以外的其他位置。这可能是您遇到权限问题的原因之一。|1310236|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

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.

blocks|key|1310270|text|是的，这是安全问题。检查启动SQL+server+2008时所使用的文件夹权限和服务帐户。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1310271|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Yes, it is security issue. Check folder permissions and service account under which SQL server 2008 starts.

blocks|key|1095093|text|当没有足够的可用空间来创建备份时，我就遇到过这个错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1095094|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I've faced this error, when there was no enough free space to create backup.

blocks|key|1310350|text|我也得到了这个错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1310351|问题很简单，我必须手动为MDF和LDF文件的文件位置创建完整的目录结构。|1310352|SQL-Server没有正确地报告丢失的目录，这是可耻的！|1310353|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I got this error too.

The problem turned out to be simply that I had to manually create the full directory structure for the file locations of the MDF &amp; LDF files.

Shame on SQL-Server for not properly reporting the missing directory!

blocks|key|1310392|text|我有这个错误。在我打开"MSSQL10_50“日志文件夹中的SQLServer日志文件之前，什么都不起作用。这清楚地说明了哪个文件不能被覆盖。原来是将.mdf文件写入"MSSQL10“数据文件夹。我确保该文件夹具有与"MSSQL10_50“等效文件夹相同的SQLServer用户权限。然后一切都起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1310393|这里的问题是记录了错误详细信息，但没有报告，因此请检查日志。|1310394|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had this error. Nothing worked for me until I opened the SQLServer log file in the "MSSQL10_50" Log folder. That clearly stated which file could not be overwritten. It turned out that the .mdf file was being written into the "MSSQL10" data folder. I made sure that folder had the same SQLServer user permissions as the "MSSQL10_50" equivalent folder. Then it all worked. 

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

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

<pre><code>Backup failed for Server 'localhost\SqlExpress'. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&amp;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&amp;EvtID=Backup+Server&amp;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&amp;ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&amp;LinkId=20476
</code></pre>

Can anyone explain what I'm doing wrong here ??

thanks

SQL server 2008 backup error - Operating system error 5(failed to retrieve text for this error. Reason: 15105)

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

有人能帮我吗?我正在尝试备份一个位于localhost\SQLEXPRESS上的数据库，但我一直收到以下错误：Backup failed for Server 'localhost\SqlExpress'.  (Microsoft.SqlServer.SmoExtended)For help, click: http:...

问SQL server 2008备份错误-操作系统错误5(无法检索此错误的文本。原因: 15105)
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server 2008备份错误-操作系统错误5(无法检索此错误的文本。原因: 15105)EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server 2008备份错误-操作系统错误5(无法检索此错误的文本。原因: 15105)
EN