Here is something to you should be aware of:
In SQL Server 2005 (not in 2008) when you drop
a snapshot database, the entire procedure cache of
the instance of SQL Server will be cleared (flushed) !
It will cause a recompilation of all subsequent execution plans
and you will see temporary excessive CPU usage and
decrease in query performance.
For more information: