Backing up data and vital information is the most important task in the world of computing. Backup should be performed nightly; therefore, it is advised to backup the Connect database engine (Connect database) and the Connect content nightly in case a restoration is necessary. In this article, we will discuss ways to perform the backup, however, this article does not suggest this is the only process or method to perform the backup. You should follow your company's policy on backing up data.

Connect Presentation, Connect Training and Acrobat Connect Professional utilize the Connect database engine and Connect writes its content to the disk drive. Connect supports both the Connect Database Engine and Microsoft SQL Server 2000. The backup process may differ, depending on which database version you deploy.

The Connect Database Engine does not use a GUI and it is accessible via Command Prompt. However, you may be able to use the Microsoft SQL Server Enterprise Manager client to interface with the Connect database engine and, as a result, you can use the Microsoft SQL Server Enterprise Manager client to schedule your database backup. This method will be discussed later.

When installing Connect , if you choose to deploy Connect with the Connect Database Engine, by default, the Connect Database Engine is installed into C:\MSSQL.

Backing up the Connect Database Engine using the Command Prompt

Follow the instructions below to back up the Connect Database Engine using the Command Prompt:

  1. Logon to the Connect server, either through the server console or Remote Desktop Connection.
  2. Create a folder called C:\Connect_Database_Engine to store the database backup.
  3. Launch the Command Prompt.
  4. Change directory to C:\MSSQL\Binn.
  5. Log into the Connect Database Engine using the following Microsoft SQL command:

    osql -U sa -P password -ddatabase-name

    For example: osql -U sa -P MyPass -d breeze

  6. Now that you have logged into the Connect Database Engine, execute the following Microsoft SQL utility to back up the Connect database (database-name):
    1. BACKUP DATABASE connect TO DISK = 'C:\Connect_Database_Engine\connect.bak' [enter]
    2. go [enter]
    You will see some messages regarding the back up. If the backup is successful, you will see a file named breeze.bak created in the C:\Connect_Database_Engine folder.
  7. To logout of the Connect Database Engine, enter:

    quit [enter]
  8. The Connect database is now backed up.

Note: You can also backup the connect.bak to a backup tape.

Watch the demonstration below for the steps to back up the Connect database using the command prompt.


Backing up the Connect Database using the Microsoft Enterprise Manager Client.

Earlier in this article, we mentioned that you can interface the Connect Database Engine with Microsoft SQL Server Enterprise Manager Client. With the Microsoft SQL Server Enterprise Manager Client, scheduling database backups is an easy task and it is not necessary to run any scripts and/or batch files or use the Command Prompt to logon to the database and run the Microsoft SQL utility called BACKUP. The following instructions and screen shots showing the steps of how to register a Breeze Database Engine within the Microsoft SQL Server Enterprise Manager.

  1. Logon to the system where Microsoft SQL Server Enterprise Manager Client has been installed. This could be the desktop PC.
  2. Launch Microsoft SQL Server's Enterprise Manager.
  3. The next several screen shots will walk you through the process of registering a Connect Database Engine:
    1. Click "Microsoft SQL Servers".
    2. Right click "SQL Server Group" and select "New SQL Server Registration".
    3. Follow the screen shots:

    4. Either enter the Connect Database Engine server name into the "Available servers:" field or select the Connect Database Engine server name from the list and click Add and click Next.
    5. Select "The SQL Server login information that was assigned to me by the system administrator [SQL Server Authentication]" and click Next.

    6. Enter sa for Login name and enter the password assigned to the sa account (or the user assigned to this Connect database and click Next.

    7. Click Next.

    8. Click Finish.

    9. The registration process is complete:

      Click Close and press F5 on your keyboard to refresh the database listing. You will see the Connect Database Engine server name under the SQL Server Group.
  4. Expand the new Connect Database Engine (for example, PS-BREEZEWIN3) by clicking the + symbol. See the screen shot below:
  5. Next, select the database called breeze and select Tools > Backup Database. You will see the next screen, where you can schedule your backup. Schedule the backup accordingly.

Backing up Connect content:

Backing up the Connect Database Engine is important, however, backing up the Connect content is also imperative. All Connect content and data, such as presentations and archive meetings, should be backed up. The content is located in C:\Breeze\content. It is highly recommended that the folder content be backed up nightly in the event that you need to restore.