
ADOBE CONNECT ENTERPRISE SERVER 6
Installation and Configuration Guide
9
Back up the SQL Server database
If you are using Microsoft SQL Server 2000, you can use SQL Server Enterprise Manager to back up your database.
Important: Do not uninstall the database.
1 In Windows, select Start > All Programs > Microsoft SQL Server > Enterprise Manager.
2 In the Tree pane of the Enterprise Manager window, select the database (named “breeze,” by default).
3 Select Tools > Backup Database.
Note: For complete instructions for SQL Server database backup and recovery, see the Microsoft Support site.
Back up the embedded database
If you are using the embedded database, use the following procedure to create a backup of the database.
Important: Do not uninstall the database.
1 Log on to the server hosting Connect Enterprise Server.
2 Create a folder to store the database backup files.
This example uses the folder c:\Connect_Database.
3 From your Windows desktop, select Start > Run.
4 In the Run dialog box, type cmd in the Open box.
5 At the prompt, change to the directory where you installed the database. By default, the directory is MSSQL\binn.
6 At the MSSQL\Binn prompt, type osql -E -Q “BACKUP DATABASE breeze TO DISK =
'c:\Connect_Database\breeze.bak'”
and press Enter.
A message indicates whether the backup was successful.
When you use the -E command, you enter SQL in “sa” mode.
To access help information for database commands, type
osql ? at the DOS prompt and press Enter.
7 At the prompt, type quit and press Enter.
8 To verify that the backup was successful, confirm that the breeze.bak file exists in the c:\Connect_Database
directory.
9 To restart your database, from your Windows desktop, select Start > Control Panel > Administrative Tools >
Services. In the Services window, right-click MSSQLSERVER and select Start from the context menu.
For more information on backing up the embedded database engine, see the Microsoft article “How to back up a
Microsoft Data Engine database by using Transact-SQL”.
Preparing to install
Connect Enterprise Server technical overview
A Connect Enterprise Server installation consists of several components: Connect Enterprise Server, Macromedia
®
Flash
®
Media Server from Adobe, and a database.
Komentáře k této Příručce