重庆思庄Oracle、Redhat认证学习论坛

标题: Could not clear 'DIFFERENTIAL' bitmap in database 'model' because of error 9002 [打印本页]

作者: 郑全    时间: 2024-4-30 09:41
标题: Could not clear 'DIFFERENTIAL' bitmap in database 'model' because of error 9002
做数据库备份,结果失败了,日志中报以下错误:

日期                2024-04-30 09:14:57
日志                SQL Server (当前 - 2024-04-30 02:38:00)

源                备份

消息
BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages.

日期                2024-04-30 09:14:57
日志                SQL Server (当前 - 2024-04-30 02:38:00)

源                备份

消息
错误: 3041,严重性: 16,状态: 1。

日期                2024-04-30 02:38:51
日志                SQL Server (当前 - 2024-04-30 02:38:00)

源                spid53

消息
Could not clear 'DIFFERENTIAL' bitmap in database 'model' because of error 9002. As a result, the differential or bulk-logged bitmap overstates the amount of change that will occur with the next differential or log backup. This discrepancy might slow down later differential or log backup operations and cause the backup sets to be larger than necessary. Typically, the cause of this error is insufficient resources. Investigate the failure and resolve the cause. If the error occurred on a data backup, consider taking a data backup to create a new base for future differential backups.

结果发现是数据库所在磁盘已经没有空间了
增加空间后,问题处理



作者: 郑全    时间: 2024-4-30 09:53
备份前端报错信息,已经很清楚:

执行SQL语句发生异常。(错误提供者:mssqlcore,错误值:40638873了,错误位置:ncMssqlDatabaseReadercpp:180)(附加信息:执行SQL语句(BACKUP DATABASE[model]TOVIRTUAL DEVICE-'37C05530-E5EE-43AE-88FF-16C0A179BC59}'with BLOCKSIZE=65536)发生错误,错误原因:[Microsof][ODBCSQLServerDriver][SQL Server]由于错退 9002,无法清除据库'mode!' 中的'DIFFERENTIAL'位图。因此,差异位图或大容量日志位图会加大下次差异备份或日志备份时的更改量。这种差异可能会降低以后差异备份或日志备份操作的速度,导致备份集比所需的要大。通常,出现这一错误的原因是资源不足。请查找该故障井解决问题。如果备份数据时出现该错误,请考唱进行数据备份来创建一个新的库,供以后进行差异备份。ErrorCode:18273,sqlstate:42000(销误提供者:mssqlcore,错误值:40638873了,错误位置:ncMssqlOdbc.cpp:1828)}




欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2