Back Up Your Existing CAM Database

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
        INIT"
                            

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' 
 WITH INIT"
                            

Where:

<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"