mssql提示The operation cannot be performed on a database错误
程序员文章站
2022-05-22 11:33:57
...
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,删除之,重新恢复数据,搞定。