mssql提示The operation cannot be performed on a database错误

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，删除之，重新恢复数据，搞定。