Database size shows huge

rsrinivasan

Hi all,

I am using SQL Server 2000. My actual database size is only 19GB. But .mdf file shows 170GB. How can i reduce it?

Thanks,

ck9663

Yes. Shrink your database and the Filegroups.

-- CK

rsrinivasan

Quote:

Originally Posted by ck9663

Yes. Shrink your database and the Filegroups.

-- CK

I shrinked that database. But it still shows 170GB in .mdf file.

Thanks,

ck9663

Did you shrink the Files?

rsrinivasan

Quote:

Originally Posted by ck9663

Did you shrink the Files?

Now I solved the problems. Thanks.

re: Database size shows huge