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
(ShailendraPune@gmail.com) writes:
> 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.
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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx