收缩日志文件错误:对数据库的备份、文件操作(如 ALTER DATABASE ADD FILE)以及加密更改必须序列化
Posted on 2012-07-24 17:09 nzperfect 阅读(8780) 评论(2) 编辑 收藏 举报错误:对数据库的备份、文件操作(如 ALTER DATABASE ADD FILE)以及加密更改必须序列化。请在当前备份或文件操作完成后重新发出该语句。
Shrink Database fails with Error “Backup, file manipulation operations”
In some cases users may get below error while trying to shrink their databases manually or using SQLServer management studio.
Executing
the query "DBCC SHRINKDATABASE(N'OperationsManagerDW', 10, TR..."
failed with the following error: "Backup, file manipulation operations
(such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized.
Possible reason:
The
backup is running when user are trying to perform the database shrink.
Please note that below operations may not be performed at the same time
as a backup operation
• File management operations such as the ALTER DATABASE statement with either ADD FILE or REMOVE FILE clauses.
• The file truncation phase of shrink database or shrink file.
Please
note that if backup is running and one of the above operations is
attempted, then operation fails immediately. When user is trying to add
or remove a file and if backups is started then backup will wait for a
timeout period, then fail.
If user is trying to shrink database
or file while a backup is running, the shrink stops without truncating
the file. If backup started after shrink database operation then backup
waits for shrink operation to complete.
Action:
Reissue the statement after the current backup or file manipulation operation is completed.
原文:http://www.sqlserver-expert.com/2012/02/shrink-database-fails-with-error-backup.html
作者:nzperfect
出处:http://www.cnblogs.com/nzperfect/
引用或者转载本BLOG的文章请注明原作者和出处,并保留原文章中的版权信息。
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 25岁的心里话
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 按钮权限的设计及实现
2009-07-24 sql server 2008 新功能创建压缩表和索引