THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

Some things don't change - DB Snapshots & Backups of Snapshots

Again, I wanted to blog about something that still does not change between 2005 and 2008. At a recent conference, there were some great questions/ideas that should make it to Connect if they haven't already.

When DB Snapshots were first introduced, one of the questions that I always heard was "Can I perform a Backup on the Snapshot?".

Well - does this mean tht you can actually perform a SQL Backup of the DB Snapshot?  No - you can't do that.  Can I backup the DB Snapshot file with Windows Backup?  Yes, you can do that, but there is no way to "re-attach" a DB Snapshot file to a database.  So why bother?

DB Snapshots are still available on a Mirrored DB.  We find that many people like this feature because of the ease of setup/management, but they do not like the fact that it is still an Enterprise Edition feature.

Published Wednesday, May 7, 2008 11:40 AM by RickHeiges

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog


Privacy Statement