Background of the issue. There is a script stored procedure for both backup and restore is running on one of the server.
I have got this from one of our customer. I have checked the restore and looks like there was a database snapshot been created that was a part of backup stored procedure.
Msg 5094, Level 16, State 2, Line 1
The operation cannot be performed on a database with database snapshots or active DBCC replicas.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Drop the database snapshot and restore the database.
Drop database <Snapshot DB Name>
T-SQL to find the database snapshot details:
SELECT * FROM sys.databases WHERE source_database_id IS NOT NULL