Operating system error 3 on database

最新推荐文章于 2021-03-29 12:38:43 发布

weixin_33766168

最新推荐文章于 2021-03-29 12:38:43 发布

阅读量203

点赞数

文章标签：数据库

本文介绍了当遇到SQL Server备份失败并提示“文件组已满”错误时的排查过程及解决方案。发现备份失败的原因在于备份设备配置不正确，指定的文件夹路径丢失导致无法完成备份任务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Today the client tell me. all database can not be backup. and give me an error. "Filegroup is full".

After i check . i found the correct resaon is backup device is not correct, the file or folder was be deleted.

The operating system returned error 21
(failed to retrieve text for this error. Reason: 15105)
to SQL Server during a read at offset 0x00000000120000 in file 'H:\Database\xxx.mdf'

System.Data.SqlClient.SqlError: Cannot open backup device 'C:\DATABASE\_shops.bak.2010-05-23-03-00-00-000.ADD'. Operating system error 3(failed to retrieve text for this error. Reason: 15105). (Microsoft.SqlServer.Smo)

The resion is the file is missing. the file or the folder has been delete .