Restoring Sql Server Database From. Ss File
The Snapshot I Created in Server Is Deleted, but I Do Have a Copy of The. Ss File. Is There a Way to Restore the Database from The. Ss File? 7 1 Answer No...
The snapshot I created in server is deleted, but I do have a copy of the .ss file. Is there a way to restore the database from the .ss file?
1 Answer
No, this is impossible.
When a database snapshot is created, the ".ss" file is basically empty. As data pages are modified in the database for the first time after snapshot creation, the original page is copied to the .ss file.
Restoring database from a snapshot will just copy back the original data pages into the database.
If there is any issue with the snapshot, SQL Server prioritizes transactions execution over snapshot integrity. So, the snapshot becomes suspect and, from that point, it's impossible to restore database to snapshot state.
How a snapshot can become suspect? many reasons:
- SQL Server can't write to the file
- disk is full
- snapshot file is too fragmented and reached some NTFS limits (see This Microsoft KB. While the article is about DBCC CHECKDB, it can also affect any snapshot)
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
