Printable View
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.
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.