SQL Tool Suite improvements

The SQL Tool Suite now provides the option to back up your database as a .bak or a .zip file. For backup archiving purposes, the .zip format provides both a significantly smaller file, and a speedier backup. Note that you can only restore from a .bak file, so if you save as .zip you will have to uncompress the backup before restoring.

In the past you may have noticed that if you have a large database (over 300 MB) a backup could not be performed. We have retooled the backup method, so now it is possible to backup any size database.

This new method also changes the way the SQL Tools Suite page responds. During theattach, backup, restore or shrink processes you will now immediately see a status monitor rather than waiting for the Control Panel page to reload.




mjp
---
DiscountASP.NET

 

My database seems to be growing at an increasingly faster rate than before and, as far as I can tell, the rate of use (added records) has been fairly constant. Do the log files get deleted after a backup or during a shrink? Is it possible that the logs are consuming more of the database space than the data?


I have done the shrink several times and only ever get back about 1%.


Dick Harrold