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

To protect your data, you should make regular backups of your data. One way to do this is with automated maintenance plans as described in the MainBoss Installation and Administration Guide. Since these facilities do backups automatically, there's no risk of losing data because someone forgot to do a backup manually.

On the other hand, some sites may prefer to do manual backups. You can do this 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 Management—see Database Management). 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.

MainBoss also makes it possible to restore databases from backup files. For more information, see Your Maintenance Organization List.

The window for viewing backup names contains the following:

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

Apply Filter: Lets you set up a filter to select which records should be shown in the table. For more information, see Table Filters.

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

File Name: The name of the backup file.

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

Database Version: The version number for the database in the last backup file. Typically, each new version of MainBoss has a new database version number; however, this isn't always the case.

Message: Any message generated when the backup was created (if any). It is important to read this message to make sure that the backup process worked.

New Backup: Opens a window where you can specify a new backup name. For more information, see Specifying Backup Names.

Edit: This drop-down button offers several possible actions:

Edit: Opens an editor window to let you edit the selected record.

View: Opens an editor window where you can examine the selected record.

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

Delete: Deletes the selected backup name. This does not delete any existing backup files that have used this name—it only deletes the name from the list.

Search: Lets you search through the list of records for a particular record. For more information, see Searching for a Particular Record. The Search button has an accompanying drop-down list containing the following:

Find Next: Uses the same search condition(s) as your most recent search and finds the next record in the table that matches the condition(s). If the search reaches the end of the table without finding a matching record, it goes to the start of the table and continues the search.

Find Previous: Same as Find Next except that it goes backward in the table. If the search reaches the start of the table without finding a matching record, it goes to the end of the table and continues the search.

Refresh: Updates the list to reflect any recent changes.

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.

See Also:

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