In MYOB Accountants Enterprise and Accountants Office, to back up your SQL database you will need to know your SQL database name.

To determine your SQL database name use the following process from within MYOB:

1. Follow the menu path: Maintenance > Maintenance Maps > Tax > Tax Settings. The Tax Settings tab displays.

2. In the AE or AO database area locate the Database Name field. The Database Name has been identified.

For instructions on this process, refer to KB 33978: How do I back up a SQL database using Management Studio? .

Perform the following process from within MYOB AE or AO:

1. Follow the menu path: Maintenance > Maintenance Maps > Documents > Document Manager Setup. The Document Manager Setup tab appears.
2. Click Document File Store in the Welcome tab. The File Store tab appears.
3. Note the path in the File Store Location field. The location of your Document Manager File Store has been determined.

Perform the following instructions from within MYOB AE or AO:

1. Click the Intranet icon. The Intranet tab displays.
2. Click the Administration link. The MYOB Intranet Administration window opens.
3. Follow the menu path: Tools > Configuration. The Configuration window opens.
4. Locate and note the information in the Contents Path field. You have now noted the location of the Intranet Data on the Server.

Tape backup differences for a full, differential and incremental backup

A full backup of your SQL database and data file store is highly recommended due to the multiple files that may need restoring if a corruption occurs.

Incremental backups though commonly used as a backup strategy fall into the high risk category for data loss\downtime, as the possibility for a tape backup failure over successive days or time taken to search for a particular file on a tape off-site that needs restoring may add to the downtime incurred.

The table below outlines differences between tape backups.