Great article Gail!!! I'd love to see a follow-up where you measure the effects that snapshots on a mirrored database (on the mirror partner) running in synchronous mode has on the principal partner.
My blog: SQL Soldier[/url] SQL Server Best Practices: SQL Server Best Practices Twitter: @SQLSoldier My book: Pro SQL Server 2008 Mirroring[/url] Microsoft Certified Master: SQL Server, Data Platform MVP Database Engineer at BlueMountain Capital Management[/url]