E-Books for you

Committed transactions not yet written to disk remain in the transaction
log and are rolled forward during the recovery process as the database is brought back
online. Incomplete transactions are rolled back during recovery. In Chapter 3, I??™ll further
discuss this process of recovery that occurs when the database is brought online.
SQL Server Recovery Modes
Each individual database can be set in one of three distinct recovery modes: Full Recovery,
Simple Recovery, and Bulk-Logged Recovery. Each mode determines how the
transaction log should behave, both in active use and during a transaction log backup,
which I??™ll discuss in detail shortly.
CHAPTER 2 n MAKING DATABASE BACKUPS 16
Full Recovery
Full Recovery mode is the default recovery mode for a newly created database. All transaction
history is maintained within the transaction log, which you must manage. The
advantage to Full Recovery mode is that you can restore up to the moment a database
fails or up to a specific point in time. The drawback is that if you leave it unmanaged, the
transaction log can grow rapidly.


Pages:
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79