sql server (alternate): reduce the File Size less then Original Size in SQL 2000 -- sql server (alternate)

reduce the File Size less then Original Size in SQL 2000

ShailendraPune NO[at]SPAM gmail.com
7/25/2007 12:18:46 AM

sql server (alternate): I have one db test with one .mdf and .ldf file.
..mdf file size is 100mb and for some reson i removed all the tables
from that .mdf file and transfer it into new secondary file so all the
tables moved into secondary file now i want to reduce the first .mdf
file from 100 mb to 50mb is that possible,it's showing 90mb is free.

Please reply

Re: reduce the File Size less then Original Size in SQL 2000

Erland Sommarskog
7/25/2007 8:51:46 AM

(ShailendraPune@gmail.com) writes:
[quoted text, click to view]

Look at DBCC SHRINKFILE in Books Online.

Although I would say that with the sizes you have indicated, I would not
consider a secondary file at all. (Unless you are doing this a training
exercise.)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at