Backups within MainBoss

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.3.
For the latest version of this help file can be found here.

< Previous section  |  Table of Contents  |  Index  |  Next section >

You can perform backups within MainBoss using Administration | Backups. The general procedure is:

  1. Create one or more backup names. A backup name is the name of a file into which MainBoss should write backup data. For example, you might create seven backup names: one for each day of the week.
  2. When you want to perform a backup, select a name from the list of available backup names. Then click Backup. This submits a request to the SQL Server asking the server to create a backup. (In order to use this function, you must have SQL Server Administrator privileges.) When the backup occurs, it will overwrite any current contents of the specified backup file.
  3. The next time you want to do a backup, select a different name from the list and click Backup again. MainBoss sorts the backup names so that the oldest backup file is at the top of the list. Therefore, if you have seven backup names, and you always select the top name whenever you make a backup, your backup will always overwrite the oldest file. This makes it easy to reuse the same set of files by cycling through them.
  4. When you initiate a backup operation, MainBoss makes an appropriate note in the database history (Administration | Database History. If the backup fails for some reason, MainBoss makes note of the failure in the database history; however, if the backup succeeds, MainBoss doesn't make a history note. In other words, if there's no note about the backup failing, you can assume that it succeeded.

A number of important considerations apply to the backup name:

When you specify a backup name, the "Defaults" line in Administration | Backups specifies the computer, the directory, and the file name extension. We strongly recommend that you examine the "Defaults" line whenever you create a backup name and before you click Backup. This will avoid failed backups or accidentally creating a backup file somewhere you don't expect.

The information in "Defaults" is generated by MainBoss at the time the window is displayed. It's dependent on your SQL Server configuration. Therefore, suppose you specify a backup name of "abc". "Defaults" shows where the backup file would be written if you clicked Backup right now. However, if your SQL Server configuration changes, future backups with the "abc" backup name might be written to a different folder.

The window for viewing backup names includes the following:

Name list: As noted above, the default is to put the oldest backup file at the top of the list.

Information area: The area below the list shows information about the selected backup name/file.

Last backup: The last date/time that backup information was stored in the selected file.

Name: The name you specified for the file.

Defaults: Information telling where the backup information will be written if you click Backup right now.

Comments: Any comments you've associated with this backup name.

New Backup Name: Opens a window where you can specify a new backup name.

Backup: Begins a backup on your database. See the notes at the start of this section for further information on the backup process.

Note: If you perform backups and restores entirely through SQL Server, MainBoss won't store information about such operations. You won't see corresponding entries in the Backups list or in the database history.

When MainBoss initiates a backup in this way, it makes an appropriate entry in the database history (Administration | Database History). If the backup fails, MainBoss makes a second entry in the database history reporting the failure. If the backup succeeds, MainBoss doesn't record this—the default is to assume that the backup was successful.

< Previous section  |  Table of Contents  |  Index  |  Next section >