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]

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]

Did you shrink the Files?

Now I solved the problems. Thanks.