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.