Database Snapshot

Question

Database Snapshot

abmore

Hall of Fame

Points: 3628
More actions
July 28, 2010 at 10:10 pm

#221821

Comments posted to this topic are about the item Database Snapshot
July 29, 2010 at 1:57 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Interesting question. My first inclination was to answer no. Then I read this documentation that said that backups and restores are supported with snapshots in 2008 R2.

http://msdn.microsoft.com/en-us/library/ms189548.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

UMG Developer SSChampion Points: 13482 More actions · Answer 2

Jason,

What you looked at was "Snapshot Backups", not "Database Snapshots."

I think these are the ones he was talking about: http://msdn.microsoft.com/en-us/library/ms189940.aspx (Native standard features that don't require third party stuff.)

Interesting question, with the reference to 2008 R2 I thought maybe something changed and backups would be allowed, but I was positive that you couldn't restore a snapshot, as they are read-only.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

That makes sense. Thanks for the correction.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQL Editor SSCommitted Points: 1980 More actions · Answer 4

SQL Server does not support online restore from a snapshot backup. Restoring a snapshot backup automatically takes the database offline.

For more info visit url

http://msdn.microsoft.com/en-us/library/ms189548.aspx

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 5

Interesting question. Understanding the exact question is important. I think I need to read a little more.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

This is confusing, mainly because MS is reusing terms in a new way. I wish they had called this something else.

pjdiller SSC Eights! Points: 977 More actions · Answer 7

I know that databases can be restored from existing snapshots:

RESTORE DATABASE database_name

FROM DATABASE_SNAPSHOT = database_snapshot_name

I figured the question referred to this, but it must not have... and I was hoping R2 would let you backup an existing snapshot. Guess not?

🙂

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 8

You can restore FROM a snapshot, but you cannot restore A snapshot.

The backup would seem to be trivial. Read pages from snapshot or source db, write to disk.

Hmmm, a suggestions. Please vote: https://connect.microsoft.com/SQLServer/feedback/details/581168/allow-backup-of-database-snapshot

pjdiller SSC Eights! Points: 977 More actions · Answer 9

Done.

Also voted this up:

https://connect.microsoft.com/SQLServer/feedback/details/533288/allow-backup-restore-snapshot-databases

Megistal SSCrazy Eights Points: 8787 More actions · Answer 10

I believe it could be possible (yet difficult) implementing the feature to restore a backup while having database snapshot.