Overwriting a Maintenance Organization with Data from a Backup File

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.3.
This help file does not exist in MainBoss 4.2.3, but the index for that version can be found here.

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

You should backup your maintenance organization database on a regular basis. For an explanation of how to do this, see Backups. The Installation and Administration Guide provides additional information about backups and restores, including how to use SQL Server facilities directly.

To restore a backed-up database, you can use Restore Organization in the Maintenance Organization window (see Your Maintenance Organization List). This restore operation uses SQL Server facilities to overwrite an existing database with the data contained in a backup file.

Important Notes about Restoring Databases: There are two operations for restoring databases from backup:

In both cases, MainBoss performs the operation by submitting requests to SQL Server. You must therefore have SQL Server Administrator privileges to perform either operation.

Restore operations are run by SQL Server itself on the computer where SQL Server is running. Because SQL Server does the work, the backup file that will be used must be accessible to the login name under which SQL Server runs. Furthermore, the name of the backup file should be relative to the computer where SQL Server is running. Unless the file name explicitly begins with \\computer or a drive name (e.g. C:\), the file name will be assumed to be relative to SQL Server's home directory. (This is true even if the file name begins with a \.)

For example, suppose SQL Server is running on Computer X and you submit a restore request while working on Computer Y. MainBoss will ask you to specify the name of the backup file containing the database you want to restore. Suppose you give the name


You may think this refers to a file on Computer Y's C: drive. However, the restore operation is performed by SQL Server on Computer X; therefore, SQL Server will try to find the file on Computer X's C: drive, not Computer Y. If the directory C:\MyBackups doesn't exist on Computer X (or if SQL Server's login name doesn't have permissions to read that folder), you'll get an error message and the restore operation won't work.

For this reason, we recommend that you only submit restore requests while logged in to the computer where SQL Server is running. You should also be aware of what permissions SQL Server has and what files will actually be accessible to SQL Server's login name.

Command Format: When you click Restore Organization, MainBoss displays a window that contains the following:

Database Server: The network location of the SQL Server through which you will access the database. For more information, see the Installation and Administration Guide.

If you click the accompanying "..." button, MainBoss displays a list of database servers that are known to your Windows system. There may be additional servers that you can use but that Windows doesn't currently know about. For more, see The Database Server List.

Database Name: The name of the database you want to overwrite. If you want to see what MainBoss databases already exist, click the "..." button at the end of the "Database Name" line. (For more, see The Database Name List.)

Organization Name: A name that you personally will use for this database. It is not necessarily the name of the database itself (although it can be). Since this is just a label for your own convenience, it can contain blanks and other characters that aren't allowed in actual database names.

Note: MainBoss automatically fills in "Database Server", "Database Name" and "Organization Name" from the Maintenance Organization you selected before you clicked Restore Organization.

Make browsers smaller by not showing details for selected record by default: If you checkmark this box, MainBoss will automatically hide the details panel when displaying tables in this database. For more, see Hiding the Details for a Selected Record. Note that you can still ask MainBoss to display the details panel for a particular table by pressing the button for displaying details.

Default MainBoss mode: The default mode in which this database should be opened. If you do not specify a mode explicitly, the database will be opened in the given mode. For more on modes, see Your Maintenance Organization List.

Restore Data: Fill in the field with the name of a backup file or with an entry from your list of backup names (as given in Administration | Backups). If you choose a name from your list of backup names, MainBoss tries to restore from the associated backup file. For more on backup names, see Backups.

OK: MainBoss submits a request to SQL Server asking to overwrite the given database with data from the backup file. You must have appropriate permissions to perform this operation.

Cancel: Closes the window without restoring.

Note: Instead of using Restore Organization, you may prefer to use the standard restoration facilities within SQL Server Management Studio or Management Studio Express. For more information, see the Installation and Administration Guide.

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