Backing up an SQL database using Management Studio

This support note applies to:

• AO Tax (AU)
• AE Practice Manager (AU)
• AE Document Manager (AU)
• AE Tax (NZ)
• AO Corporate Compliance (AU)
• AE Tax Series 6 & 8 (AU)
• AE Tax (AU)
• AE Corporate Compliance (AU)

In MYOB Accountants Enterprise (AE) and Accountants Office (AO), you may need to take an SQL backup of your database.

The following instructions will guide you through how to back up your AE/AO databases using SQL Server Management Studio.

If your environment is a:

• Server or network
• Standalone PC.

The backup of your SQL database should also be included on your external backup system. For example, a tape backup or on an external hard drive.

To back up using SQL Server Management Studio

1. From the desktop of your server or standalone, follow the menu path: Start > Programs > Microsoft SQL Server 20xx > SQL Server Management Studio. The Connect to Server screen appears.
2. Complete the fields as required and click Connect. The Microsoft SQL Server Management Studio screen appears.
3. Right-click on the database you want to back up and from the Tasks menu, select Back Up. The Back Up Database screen appears.
4. If a file is listed in the Back up to field in the Destination section, click Remove. The file is cleared from the field.
5. If there is no file, or once the file is cleared at step 4, click Add. The Select Backup Destination screen appears.
6. Select the location, type the backup database name and click OK. The Back Up Database screen appears.
7. Click OK to begin the backup. When the backup is completed the prompt 'The backup of database completed successfully' appears.
8. Click OK. The Microsoft SQL Server Management Studio screen appears.

If you have issues performing the SQL Server Management Studio backup, contact your IT provider.