SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What is the benefit of Database Snapshots ?


What is the benefit of Database Snapshots ?

Author
Message
MohamedDBA
MohamedDBA
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 217
What is the benefit of Database Snapshots , also are every DBA should deal with it daily , please explain in simple way.
Elliott Whitlow
Elliott Whitlow
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23632 Visits: 5314
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
Steve Hall
Steve Hall
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5094 Visits: 11864
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.

Steve Hall
Linkedin
Blog Site
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)

Group: General Forum Members
Points: 97253 Visits: 33013
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search