Sybase 12.4.2 Server User Manual


 
377
CHAPTER 11
Backup and Data Recovery
About this chapter
This chapter explains how to back up your database, and how to recover
data when necessary. It tells you why it is important to perform backups
on regular basis, and gives recommendations for scheduling backups.
Backup protects your data
Adaptive Server IQ provides a full set of features that protect you from
two types of computer failure, and from database corruption.
•A system failure occurs when the computer or operating system goes
down while there are partially completed transactions. This could
occur when the computer is inappropriately turned off or rebooted,
when another application causes the operating system to crash, or
because of a power failure.
•A media failure occurs when the database file, the file system, or the
device storing the database file, becomes unusable.
After a system failure, Adaptive Server IQ can usually recover
automatically, so that you may not need to restore your database.
Recovery from system failures is discussed in Adaptive Server IQ
Troubleshooting and Error Messages Guide.
After media failure, or if for any reason the data in your database is
corrupted, you must restore your database. To protect your data in all of
these situations, make regular backups of your databases. In particular,
you should back up your database each time you finish inserting any large
quantities of new data into the database.
When failures occur, the recovery mechanism treats transactions properly,
as atomic units of work: any incomplete transaction is rolled back and any
committed transaction is preserved. This ensures that even in the event of
failure, the data in your database remains in a consistent state.