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