Thanks, Vladimir! 😉

Here's an article on how to revert a database to a snapshot

http://msdn.microsoft.com/en-us/library/ms189281.aspx

and here's a good article on when and how to use a snapshot.

http://searchsqlserver.techtarget.com/tip/SQL-Server-2005-When-and-how-to-use-Database-Snapshots

Joe

A database snapshot is a point-in-time, read-only copy of a database. Here's a link with good info on snapshots.

http://msdn.microsoft.com/en-us/library/ms175158.aspx

Joe