THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
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 07, 2008 11:40 AM by RickHeiges

Comments

No Comments
Anonymous comments are disabled
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement