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-Enthusiastic
SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)

Group: General Forum Members
Points: 173 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 Guru
SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)SSC Guru (58K reputation)

Group: General Forum Members
Points: 58422 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
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10103 Visits: 12352
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 (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)SSC Guru (223K reputation)

Group: General Forum Members
Points: 223477 Visits: 33564
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