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

What is the benefit of Database Snapshots ? Expand / Collapse
Author
Message
Posted Sunday, December 8, 2013 3:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 4, 2014 10:06 AM
Points: 29, Visits: 217
What is the benefit of Database Snapshots , also are every DBA should deal with it daily , please explain in simple way.
Post #1520860
Posted Sunday, December 8, 2013 9:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
In most cases the schedule will be set by the business and that schedule will be automated so the DBA probably won't be doing much with it.

For me, most of the uses I have found have been related to reporting. I needed to capture data at a point in time to report on. I could copy the data or some other method but I couldn't easily just freeze a database in a particular state without snapshots.

One of the reasons to use them is they are very easy to setup and then the system handles the under the covers work.

CEWII
Post #1520906
Posted Monday, December 9, 2013 1:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:10 AM
Points: 1,539, Visits: 8,136
Testing. If I'm testing something against a test database, by using Snapshots I can restore the data back to the state it was in a few seconds rather than the 15-20 minutes that some of my backups take to restore. It also saves space on my test environment as the Snapshot is not as large as the series of backups I would normally take whilst testing.

BrainDonor
Linkedin
Blog Site
Post #1520942
Posted Monday, December 9, 2013 7:56 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:03 AM
Points: 15,561, Visits: 27,938
When I'm deploying database changes to an Enterprise system, I'll use snapshots to make rollbacks very fast and easy should something go wrong during the deployments. I won't keep those snapshots for any length of time once we've validated that the deployment was successful.

As for cleaning them up on a schedule, it really depends on why they're being created. What makes you think it's something you need to do on a scheduled basis?


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1521103
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse