I’ve recently been investigating the applicability of SQL Server Database Snapshots (Enterprise Edition-only) for reporting scenarios and came across this excellent Simple-Talk article describing pros and cons: A DBA’s view on SQL 2005 Database Snapshots.