March 25, 2003 at 6:04 am
Is there anything else you can do to reduce the size of the DB? I already have the properties set for autoshrink.
March 25, 2003 at 6:37 am
You can shrink it manually, file by file. Is it your transaction log that is growing on you? If so then backing up the log more often might help.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 6:42 am
I already learned the log file lesson the hard way when it had grown to 9GB and crashed the system. It gets backed up each day and now remain around 100MB. How is manually shrinking different than the autoshrink property?
March 25, 2003 at 7:32 am
It is not different really, just that you can control it better. Other than this, there really aren't much you can do. If you have 4 GB of data you can't compact it to less than 4 GB, there is no functionality to compress data in SQL Server. Of course you can check settings for fillfactor of indexes, and check the amount of fragmentation in your tables.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply