Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database Snapshot Expand / Collapse
Author
Message
Posted Wednesday, July 28, 2010 10:10 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 2:36 AM
Points: 1,158, Visits: 878
Comments posted to this topic are about the item Database Snapshot
Post #960460
Posted Wednesday, July 28, 2010 10:12 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 17,805, Visits: 15,716
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
Post #960461
Posted Wednesday, July 28, 2010 10:26 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
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.
Post #960467
Posted Wednesday, July 28, 2010 10:31 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 17,805, Visits: 15,716
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
Post #960469
Posted Thursday, July 29, 2010 1:39 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 6:09 AM
Points: 697, Visits: 356
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

Post #960530
Posted Thursday, July 29, 2010 1:57 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 12:53 PM
Points: 4,011, Visits: 5,305
Interesting question.
Had to make sure of my facts before answering (just in case something changed with R2)


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #960534
Posted Thursday, July 29, 2010 6:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:36 PM
Points: 2,818, Visits: 2,565
Interesting question. Understanding the exact question is important. I think I need to read a little more.
Post #960658
Posted Thursday, July 29, 2010 10:03 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:49 PM
Points: 31,161, Visits: 15,607
This is confusing, mainly because MS is reusing terms in a new way. I wish they had called this something else.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #960847
Posted Thursday, July 29, 2010 1:43 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, March 15, 2014 1:45 PM
Points: 405, Visits: 286
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?

Post #960988
Posted Thursday, July 29, 2010 2:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:49 PM
Points: 31,161, Visits: 15,607
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #961001
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse