Paul Randal (1/11/2010)
...snapshot just can't get bigger than the database - once all pages from the database are copied, there's nothing else that can make the snapshot grow.
True, but it could appear that way:
Consider a database 80GB in size.
A snapshot of that database reaches 78GB in size.
Objects are then deleted from the main database.
The main database is then shrunk to 1GB.
The snapshot is now larger than the database, since extents are never deallocated from the snapshot.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi