User Guide

Maintaining Breeze reliability 89
• Establish a system for overwriting backups, reusing the oldest backups first.
• Use expiration dates on backups to prevent premature overwriting.
• Label backup media to prevent overwriting critical backups. This allows for easy identification
of the data stored on the backup media or the specific backup set.
Backing up the Breeze database with SQL Server utilities
The following utilities are available for creating a backup of a SQL Server database:
• Tr a n s a c t - S Q L
• Enterprise Manager
• SQL-DMO
• Create Database Backup Wizard
If you are using MS SQL Server 2000, you can use the Enterprise Manager to back up your
database.
• In Windows, select Start > Programs > Microsoft SQL Server > Enterprise Manager.
• In the Tree pane of the Enterprise Manager window, select the Breeze database (named
“breeze,” by default).
• Select Tools > Backup Database.
Macromedia recommends a nightly backup of the Breeze database. Complete instructions for
SQL Server database backup and recovery are available at the Microsoft Support site.
Backing up the Breeze database with the embedded database engine
If you are using the embedded database engine, use the following procedure to create a backup of
the Breeze database.
To create a Breeze database backup:
1. Log in to the embedded database engine:
osql -U sa -P password -d databasename
2. Run the MSSQL BACKUP DATABASE utility to back up the database.
For example:
BACKUP DATABASE databasename TO DISK = 'c:\msde\backup\databasename.bak'
This command writes the database named databasename.bak to the hard disk located in
c:\msde\backup.
3. Enter the following command to back up the database to tape:
go