dbcc shrinkdatabase('cdr') DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages 5 1 8251208 80 7943048 7943048 5 2 4285472 63 4285472 56 Franck::D:\DB>dir Volume in drive D is FRANCK-D Volume Serial Number is 7081-D2B6 Directory of D:\DB 08/17/2008 11:24 AM . 08/17/2008 11:24 AM .. 08/17/2008 11:24 AM 573 after 08/16/2008 10:22 PM 528 before 05/13/2010 10:25 PM 110,636,105,728 cdr.mdf 05/13/2010 10:25 PM 11,185,881,088 cdr_log.ldf 05/13/2010 10:25 PM 469,041,152 Test.mdf 05/13/2010 10:25 PM 397,869,056 Test_log.ldf 6 File(s) 122,688,898,125 bytes 2 Dir(s) 325,427,937,280 bytes free Franck::D:\DB>dir Volume in drive D is FRANCK-D Volume Serial Number is 7081-D2B6 Directory of D:\DB 08/17/2008 11:24 AM . 08/17/2008 11:24 AM .. 08/17/2008 11:24 AM 573 after 08/16/2008 10:22 PM 528 before 05/14/2010 07:33 AM 67,593,895,936 cdr.mdf 05/14/2010 07:33 AM 35,106,586,624 cdr_log.ldf 05/13/2010 10:25 PM 469,041,152 Test.mdf 05/13/2010 10:25 PM 397,869,056 Test_log.ldf 6 File(s) 103,567,393,869 bytes 2 Dir(s) 344,689,528,832 bytes free dbcc shrinkdatabase('cdr_archived_versions') DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages 7 1 16131560 80 16128728 16128728 7 2 63 63 56 56 Franck::D:\Program Files\Microsoft SQL Server\MSSQL\Data>dir Volume in drive D is FRANCK-D Volume Serial Number is 7081-D2B6 Directory of D:\Program Files\Microsoft SQL Server\MSSQL\Data 08/16/2008 08:22 AM . 08/16/2008 08:22 AM .. 05/13/2010 10:25 PM 142,872,215,552 cdr_archived_versions.mdf 05/13/2010 10:25 PM 1,032,192,000 cdr_archived_versions_log.LDF 05/04/2005 12:32 AM 786,432 distmdl.ldf 05/04/2005 12:32 AM 2,359,296 distmdl.mdf 05/13/2010 10:25 PM 17,760,256 master.mdf 05/13/2010 10:25 PM 2,359,296 mastlog.ldf 05/13/2010 10:25 PM 655,360 model.mdf 05/13/2010 10:25 PM 1,310,720 modellog.ldf 05/13/2010 10:25 PM 15,990,784 msdbdata.mdf 05/13/2010 10:25 PM 2,359,296 msdblog.ldf 05/13/2010 10:25 PM 8,388,608 tempdb.mdf 05/14/2010 12:53 AM 786,432 templog.ldf 12 File(s) 143,957,164,032 bytes 2 Dir(s) 344,907,169,792 bytes free Franck::D:\Program Files\Microsoft SQL Server\MSSQL\Data>dir Volume in drive D is FRANCK-D Volume Serial Number is 7081-D2B6 Directory of D:\Program Files\Microsoft SQL Server\MSSQL\Data 08/16/2008 08:22 AM . 08/16/2008 08:22 AM .. 05/14/2010 12:52 PM 132,149,739,520 cdr_archived_versions.mdf 05/14/2010 12:52 PM 516,096 cdr_archived_versions_log.LDF 05/04/2005 12:32 AM 786,432 distmdl.ldf 05/04/2005 12:32 AM 2,359,296 distmdl.mdf 05/13/2010 10:25 PM 17,760,256 master.mdf 05/13/2010 10:25 PM 2,359,296 mastlog.ldf 05/13/2010 10:25 PM 655,360 model.mdf 05/13/2010 10:25 PM 1,310,720 modellog.ldf 05/13/2010 10:25 PM 15,990,784 msdbdata.mdf 05/13/2010 10:25 PM 2,359,296 msdblog.ldf 05/13/2010 10:25 PM 8,388,608 tempdb.mdf 05/14/2010 12:53 AM 786,432 templog.ldf 12 File(s) 132,203,012,096 bytes 2 Dir(s) 356,661,321,728 bytes free