I wanted to remove user data from a database to make a new version of the database with no user data, then restore the database to the original state. To save the time it takes to run a backup of a 600GB DB, I create a database snapshot which I could revert to later. My steps were:
1) Create a snapshot of database A
2) Run stored procedure to drop 500+ GB of userdata
3) Run DBCC SHRINKDATABASE to shrink the data files
4) Run Full Backup job
5) Run ALTER DATABASE commands to regrow DB files to their previous size
5) Run RESTORE DATABASE <database name> FROM DATABASE_SNAPSHOT = '<Snapshot name>'
This produces the result:
"Msg 3137, Level 16, State 1, Line 2
Database cannot be reverted. Either the primary or the snapshot names are improperly specified, all other snapshots have not been dropped, or there are missing files.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally."
There are no other snapshots and no Read Only filegroups. Recovery mode is SIMPLE. What went wrong? Did I do too much stuff to the DB?