Running the SQL database shrinker
This support note applies to:
- Profiles (AU)
- AE Tax Series 6 & 8 (AU)
These instructions require technical expertise
Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.
In MYOB Accountants Enterprise (AE) you may experience the error "The database AETAX1 is reaching its maximum allowed size for the version of SQL Server installed" when performing a Datasafe backup.
This error occurs when the database is near the size limit.
To resolve this error run the SQL database shrinker in DataSafe to compact an SQL or MSDE database.
When you perform the DataSafe backup, this process checks if the AE Tax MSDE\SQL database is nearing the size limit and therefore requires compacting.
- Open DataSafe and click Support Tools.
- Select SQL Shrinker from the Utility drop-down list in the bottom half of this window, then click Run Now.
- Click on the Next button to continue.
Select the required server in the Server Name drop down list. The Program defaults to Use MSyncUser login account which will work for compacting any of the AE Tax databases.
You may use this utility on any SQL database by using the appropriate login for the database you wish to compact.
- Click Next to continue.
- Highlight the database you want to shrink. The wizard defaults to set 10% for free space, this amount should not be changed unless otherwise advised by MYOB Support.
- Click Next to continue.
- Click Finish to complete the wizard.