Back Up Your Existing CAM Database

If you are upgrading from an earlier version, you should back up your existing CAM database prior to performing the upgrade to a new version.

Preparing to Back Up the CAM database

Before backing up the CAM database, have the following information handy:

  • The name of your CAM database
  • The SQL Server administrative account name (typically "sa") and password

If you have a full SQL Server installation, you can use the SQL Server Enterprise Manager utility to create the backup. If you do not have this tool, you can create a backup by using OSQL, the SQL command line utility.

Backing Up from the SQL Server Machine

To back up your CAM database from the machine where SQL Server is installed:

  1. Bring up a DOS box.
  2. Issue the following command:
                                osql -S<server-name\instance-if-any> -E  -Q"BACKUP DATABASE
        <database-name> to disk = '<path>\<database-name>.bak' WITH

Backing Up the Database from Another Machine   

If you are creating the backup from a different machine (which still requires that OSQL is installed on the machine):

  1. Bring up a DOS box.
  2. Issue the following command:
                                osql –S<database-server> -U<user> -P<password> 
 -Q"BACKUP DATABASE <database-name> to disk = '<UNC path>\<database-name>.bak' 


<database-server> is the name of the machine on which SQL Server is installed

<user> is the SQL Server administrative account (typically sa)

<password> is the password for that account

<database-name> is the name of your CAM database

<UNC path> is the location you want the backup file written in the context of the SQL Server machine

For example, if your database server is called CAMdbSrv, you are using the default CAMDB database with a password of "sapwd" on the "sa: account and you have shared out a folder as "temp" on your database server, the command would be:

                                osql –SCAMdbSrv –Usa –Psapwd -Q"BACKUP DATABASE CAMDB to disk =
          '\\CAMdbSrv\temp\CAM.bak' WITH INIT"
The \\CAMdbSrv\temp directory must exist and be shared out, and the CAM.bak file cannot exist; it will be created in the specified folder on the database server machine.

The location of the backup file is specified in the context of the machine running SQL Server, NOT the machine on which the OSQL command is issued. This means that:

  • If backing up using a local path specification, the path is on the SQL Server machine.
  • If backing up to a network share, the account under which SQL Server is running must have proper credentials to access that share.