A snapshot database is NOT <= Original. It will be = Original minus the log.
See proof below. Commands in black, results in red.
exec sp_helpdb UPSRC -- show size of original database (approx 301 GB)
name db_size owner
--------------- ------------- --------------------
UPSRC 301718.13 MB RAINBIRD\PSAdmin
name fileid filename size
--------------- ------ ----------------------------- -------------
rbprod_data 1 F:\mssql\data\UPSRC_Data.mdf 253744832 KB
rbprod_log 2 F:\mssql\data\UPSRC_Log.ldf 55214528 KB
CREATE DATABASE UPSRC_Snap
ON (NAME = rbprod_data, FILENAME = 'f:\mssql\data\upsrc_snap.ss') AS SNAPSHOT OF UPSRC
exec sp_helpdb UPSRC_Snap -- show size of snapshot database (approx 301GB)
name db_size
------------- --------------
UPSRC_Snap 301718.13 MB
name fileid filename size
--------------- ------ ------------------------------ --------------
rbprod_data 1 F:\mssql\data\UPSRC_Data.mdf 253744832 KB
rbprod_log 2 F:\mssql\data\UPSRC_Log.ldf 55214528 KB
dir f:\mssql\data (show size of database files on disk)
11/27/2006 07:13 PM 259,834,707,968 UPSRC_Data.mdf
11/27/2006 07:13 PM 56,539,676,672 UPSRC_Log.ldf
12/11/2006 04:12 PM 259,834,707,968 upsrc_snap.ss