How to shrink a 171 GB size SQL 2005 database !!!
Posted on 2008-10-08
Few days agao I posted a similar question abpout shrinking a specific database, and the conculusion was that it cannot be shrink. This time it is a different database and the log file is big which make me thin that it can be shrink. Please read below.
I have a 171 GB database. I want to shrink this database as much as possible.
Under SQL Managment studio when I see the property of this database, the size of the database is 174335.94 MB and the space available is 4144.27 MB.
The Files for this database and have following sizes.
MDF size = 14272 KB
NDF size = 82286016 KB
LDF size = 96219712 KB
When i run sp_spaceused I get the following numbers;
DatabaseSize: 174335.94 MB
UnAllocatedSpace: 4144.27 MB
Reserved: 78056560 KB
Data: 64241760 KB
IndexSize: 13774472 KB
Unused: 40328 KB
I dont want to corrupt or lose the data.
Please suggest the best & easist way to reduce the size of this database as much as possible.
Thanks a million for your prompt help.