Microsoft SQL Server Automatic Recovery
SQL Server uses the records stored in the transaction log to perform automatic data recovery in the case of a power failure or an unclean shutdown of SQL Server in which data is not damaged or corrupted in any way. In this case, backups are not needed to recover the database. This is normal SQL Server operation. Automatic recovery occurs per database every time SQL Server starts up and occurs with all of the recovery models—simple, bulk-logged, or full—discussed in the next section. SQL Server always logs enough data in the transaction log to be able to perform automatic recovery when necessary, even with the simple recovery model.
When a system failure such as a power loss occurs, there may be transactions ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
