Shrinking my SQL database using SQL Management Studio
This support note applies to:
- AE Practice Manager (NZ)
- AE Practice Manager (AU)
- AE Tax (NZ)
- AE Tax Series 6 & 8 (AU)
- AE Tax (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.
If the database size is larger then expected, you can run a database shrink that will reduce it size. This is only effective on the LOG file if the database is set to simple recovery and not full where the transactional data is retained.