is it possible to use a snapshot in any way to create a new database?

Question

Post reply

is it possible to use a snapshot in any way to create a new database?

snomadj

SSCarpal Tunnel

Points: 4491
More actions
July 30, 2019 at 1:35 pm

#3667214

Can I … backup from a snapshot? With a view to using the backup as a restore.
Or in any other weird or secret way I don't know about use a snapshot to create a new database.
2008 R2.

I know I can revert to source … not interested in this at this stage.

Thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

BrainDonor SSCoach Points: 19254 More actions · Answer 1

No, the documentation is quite clear about that.

"You cannot back up or restore database snapshots."

Steve Hall
Linkedin
Blog Site

Andrey Right there with Babe Points: 780 More actions · Answer 2

https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-snapshots-sql-server#LimitsOnDbSS

snomadj SSCarpal Tunnel Points: 4491 More actions · Answer 3

Eurgh. Thank you. I’ve had a Microsoft guy on site telling me that it’s possible. I said not. But he’s Microsoft so I doubted myself even though the docs and tests proved him wrong. Appreciate the confirmation there’s no undocumented way.

rVadim Hall of Fame Points: 3969 More actions · Answer 4

Perhaps Microsoft guy meant reverting source database to the state it was when snapshot was taken? That's possible.

--To Revert a Database to a Database Snapshot:
RESTORE DATABASE { database_name | @database_name_var }
FROM DATABASE_SNAPSHOT = database_snapshot_name

--Vadim R.

snomadj SSCarpal Tunnel Points: 4491 More actions · Answer 5

Not in the scenario we were discussing but yes, perhaps it was a miscommunication of some sort. Thanks for helping me clear it up!