|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 4:43 PM
Points: 21,861,
Visits: 6,081
|
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Thursday, November 05, 2009 5:35 PM
Points: 374,
Visits: 143
|
|
| As far as I know, when you create a Snapshot, it reserves disk space to match the database size. If the drive doesn't have that amount of disk space you can't create the snapshot. If it does, as I said, the disk space is reserved. So: how can a snapshot run out of disk space??
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 14,804,
Visits: 10,597
|
|
A snapshot is a sparse file. The size of the file appears to be the size of the database, but it hasn't reserved that much space on the disk. The size on disk is much, much smaller, the size only of the data inside.
See the section in Books Online "Understanding Sparse File Sizes in Database Snapshots"
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Tuesday, November 17, 2009 10:32 AM
Points: 636,
Visits: 80
|
|
| When I drop a snapshot and recreate it, then it isn't the same snapshot any more, is it? What if I run some kind of audit that requires the snapshot to represent a specific date and time?
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 14,804,
Visits: 10,597
|
|
Joseph (1/14/2009)
What if I run some kind of audit that requires the snapshot to represent a specific date and time?
Don't let the disk run out of space. In addition, make sure you don't have to restore or detach the database ever. Make sure you'll never need to drop files.
My personal opinion, if you have to have a copy of the database as it was at a specific point in time, take a backup and either restore it and mark the new DB readonly, or archive the backup. Snapshots are not good for long-term usage or for cases where you absolutely have to have the snapshot. There are too many reasons why you may need to drop them.
Gail Shaw
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
