File Size Reducing 2

[ehojr]

Using macola 7.6.3b, msql 2000. will purging files etc reduce the file size on disk... I think under btreive additional steps had to be run to obtain disk savings?

 

[ChrisP520]

You do not need to rebuild in an MSSQL environment. The space will be available in the database. However, you will not realize any increase in disk space until a full backup of the database has occured.

 

[dgillz]

In a Pervasive/Btrieve environment you must rebuild the files in order to regain the disk space. You can automate this task with the newer versions of Pervasive.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kscheeler]

After doing a full backup of the SQL database, go into Enterprise Manager, drill down and highlight your database, right click, all tasks and choose shrink database. There's a button that will let you shrink the database file seperately from the log file or shrinking it from the first screen will do both. If it is having problems shrinking the log file, right click on the database, choose properties, options tab and set the recovery mode to simple. Then repeat the shrinking steps. After it's done, set the recovery model back to full.

If you have the recovery model set to full, make sure you have a database maintenance plan that's doing a periodic full backup along with backing up the transaction log files or your log files will just grow, grow, grow.

Kevin Scheeler