Posted by Erland Sommarskog on 07/25/07 08:51

(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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Error: The number of failing rows exceeded the maximum specified, Help !
• Prev in forum: Re: Firehose mode
• Thread view: Re: reduce the File Size less then Original Size in SQL 2000

[Reply to this message]