The operation cannot be performed on a database with database snapshots or active DBCC replicas的解决办法
用数据库备份恢复工具去恢复数据，恢复失败，提示
The operation cannot be performed on a database with database snapshots or active DBCC replicas.
有印象的是刚程序里是做过snapshot的，猜与之有关。
进Microsoft SQL Server Management Studio里看Database snapshots里看，果然是有snapshot，删除之，重新恢复数据，搞定。
本博客所有文章如无特别注明均为原创。
复制或转载请以超链接形式注明转自枫芸志，原文地址《The operation cannot be performed on a database with database snapshots or active DBCC replicas的解决办法》
复制或转载请以超链接形式注明转自枫芸志，原文地址《The operation cannot be performed on a database with database snapshots or active DBCC replicas的解决办法》
标签： SQL Server
还没有人抢沙发呢~