摘要:
引用: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 阅读全文