Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-05-16 : 08:30:46
|
| We have a training server and I've had a request that after each training session, we have the ability to quickly roll the training server back to its previous state so that the next group of people can be trained with the same examples.Doing a restore requires that the maintenance (defrag, warm cache, etc..) also runs after that before the server performs fast enough.So I was thinking of snapshots as an alternative. When you roll back to a snapshot, does that invalidate what's in the cache or have any adverse effect on query plans, stats, or indexes? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-05-16 : 09:24:37
|
| it reverts the database to the current state when the snapshot was taken--------------------keeping it simple... |
 |
|
|
|
|
|
Maintenance after snapshot?