How to shrink a SQL 2005 database !!!
Posted on 2008-10-02
I have a 72GB database. I want to shrink this database as much as possible.
Under SQL Managment studio when I see the property of this dataabase, the size of the database is 73071.01 MB and the space available is 4705.14MB.
The Files for this database and have following sizes.
MDF file size is 14,272 KB
NDF file size is 74,805,440 KB
LDF log file size is 5,000 KB.
Please suggest the best & easist way to reduce the size of this database as much as possible.
Thanks a million for your prompt help.