Back up user data, database, and settings of Adobe Connect server

There are three types of data you must back up at regular intervals: content (any files stored in the libraries), configuration settings, and database data.

If you aren’t using shared storage devices, all the content in the libraries is stored in the [root_install_dir]\content folder (C:\Connect\content, by default). The configuration settings are stored in the custom.ini file in the root installation folder (C:\Connect, by default).

A database backup creates a duplicate of the data in the database. Regularly scheduled database backups can let you recover from many failures, including media failures, user errors, and permanent loss of a server. Back up the database daily.

You can also use backups to copy a database from one server to another. You can re-create the entire database from a backup in one step by restoring the database. The restoration process overwrites the existing database or creates the database if it does not exist. The restored database matches the state of the database at the time the backup was performed, minus any uncommitted transactions.

You create backups on backup devices, such as disk or tape media. You can use a SQL Server utility to configure your backups. For example, you can overwrite outdated backups, or you can append new backups to the backup media.

Follow best practices when backing up the database:

• Schedule a nightly backup.

• Maintain backups in a secure place, preferably at a site different from the site where the data resides.

• Keep older backups for a designated period in case the most recent backup is damaged, destroyed, or lost.

• Establish a system for overwriting backups, reusing the oldest backups first. Use expiration dates on backups to prevent premature overwriting.

• Label backup media to identify the data and prevent overwriting critical backups.

  Use SQL Server utilities to back up the database:

• Transact-SQL

• SQL Distributed Management Objects

• Create Database Backup wizard

• SQL Server Management Studio

Back up and protect system data, just as you protect all the valuable assets of your organization.

It’s a good idea to perform this procedure nightly.

To back up any edition of Microsoft SQL Server, you can use Microsoft SQL Server Management Studio or the Command Prompt window.

The edition of SQL Server that installs with Adobe Connect Server does not include SQL Server Management Studio. However, you can download Microsoft SQL Server Management Studio Express from Microsoft.

To access Help information for database commands, type osql ? at the command line and press Enter.