db size problem

[balasiva]

My db size is 1.5 gb. it only has two tables. totally 500,000 records.
I did shrink log file. how do i shrink or defragment data file. i should've probably 300mb size based on the record size.

i did try creating clustered index anbd dropped it. it didn't help.

any tips appreciated.

[Chris]

Try using the DBCC SHRINKDATABASE(database_name) command.

------------
balasiva at 5/10/01 4:09:32 PM

My db size is 1.5 gb. it only has two tables. totally 500,000 records.
I did shrink log file. how do i shrink or defragment data file. i should've probably 300mb size based on the record size.

i did try creating clustered index anbd dropped it. it didn't help.

any tips appreciated.