You'll need to shrink the database, either through Enterprise Manager or
using a sql statement on query analyzer.

-----Original Message-----
From: Suraj
[mailto:mssqldba-ezmlmshield-x51463435.[Email address protected]
Sent: Tuesday, May 31, 2005 4:01 PM
To: LazyDBA Discussion
Subject: Help on Size of MDF File

Hello, All

I have a 45 GB SQL 2000 Server DB .

I am planing to move some data to a new DB on the same server and
deleting the data from the 45GB DB .

Once I detele the data from 45GB DB , would my MDF file size go down
from 45GB?

If not, Is there any way to reduce the allocated size of MDF once you
delete data from the DB.

Any help on this would be highly appreciated.

Thanks in advance.

(Embedded image moved to file: pic20675.gif)


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page