SQL Error: The operation cannot be performed on a database with database snapshots or active DBCC replicas

  • Article

 

Usually Database snapshots provide static view of the source database, and are mostly read only view of the database.  

However sometime when you try to restore the database with snapshots we may get the following error SQL message:

Error:
"Msg 5094, Level 16, State 2, Line 2

The operation cannot be performed on a database with database snapshots or active DBCC replicas.

Msg 3013, Level 16, State 1, Line 2

RESTORE DATABASE is terminating abnormally."

 

Quick FIX: (solution)

  1. Create a new DataBase and then restore the snapshot against it.

  2. Try renaming the database before restoring,