摘要： 引用：http://msdn.microsoft.com/en-us/library/ms180892(SQL.90).aspx The SQL Server 2005 transaction log operates logically as if the transaction log is a string of log records. Each log record is identified by a log sequence number (LSN). Each new log record is written to the logical end of the log wi. 阅读全文

摘要： 引用：http://msdn.microsoft.com/en-us/library/ms186259(SQL.90).aspx最近在学习sql server事务日志的东西，知道现在大部分数据库都支持先写log再写数据的策略，也就是保证数据不先于日志写入磁盘。我们将这样的日志叫做Write-Ahead Transaction Log。Write-Ahead Transaction Log的完整解释可以在MSDN上找打，写的非常详细，也很透彻，不难懂，我把这部分内容摘录下来。Write-Ahead Transaction Log的解释SQL Server 2005 uses a write-ah 阅读全文