-
db size problem
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.
-
db size problem (reply)
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|