Macromedia breeze 5 사용자 가이드
88
Chapter 4: Post-installation
Changing the Breeze password
The password for Breeze Server allows access to the Breeze database. For the integrity of your
system security, change the default password if you’re using the Breeze database.
system security, change the default password if you’re using the Breeze database.
Note: Microsoft SQL Server 2000 users usually already have a password that the database
administrator has set.
administrator has set.
To change the database password:
1.
Open the command prompt window on the computer that is hosting the database.
2.
Log in to the Breeze database,
osql -U sa -P breeze -d breeze
3.
Enter the command for the new password, as shown in the following example:
sp_password @old=breeze, @new='NewPassword', @loginame = 'sa' go
For additional information about changing the password, see the Microsoft article, “How to
Verify and Change the MSDE System Administrator Password” at: http://support.microsoft.com/
default.aspx?scid=kb;EN-US;322336#3.
Verify and Change the MSDE System Administrator Password” at: http://support.microsoft.com/
default.aspx?scid=kb;EN-US;322336#3.
Backing up the Breeze database
A database backup creates a duplicate of the data that is in the database. This is a single operation,
usually scheduled at regular intervals. To safeguard your Breeze operations, routinely back up the
Breeze database. With regularly scheduled backups of the Breeze database, you can recover from
many failures, including media failures, user errors, and permanent loss of a server.
usually scheduled at regular intervals. To safeguard your Breeze operations, routinely back up the
Breeze database. With regularly scheduled backups of the Breeze database, you can recover from
many failures, including media failures, user errors, and permanent loss of a server.
The scheduled routine of backing up and restoring databases is useful for other purposes, such as
copying a database from one server to another. By backing up a database from one computer and
restoring the database to another, a copy of a database can be made quickly and easily.
copying a database from one server to another. By backing up a database from one computer and
restoring the database to another, a copy of a database can be made quickly and easily.
You can re-create the entire database from a database backup in one step by restoring the database.
The restore 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. Uncommitted transactions are rolled back when the database is
recovered.
The restore 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. Uncommitted transactions are rolled back when the database is
recovered.
You create backups on backup devices, such as disk or tape media. With SQL Server, you can
decide how you want to create your backups on backup devices. For example, you can overwrite
outdated backups, or you can append new backups to the backup media.
decide how you want to create your backups on backup devices. For example, you can overwrite
outdated backups, or you can append new backups to the backup media.
Best practices for backups
When working with database backups, Macromedia recommends the following best practices:
•
Schedule a nightly backup of the Breeze database.
•
Maintain backups in a secure place, preferably at a site different from the site where the data
resides.
resides.
•
Keep older backups for a designated amount of time in case the most recent backup is
damaged, destroyed, or lost.
damaged, destroyed, or lost.