Research on Redo Log Record Locating Mechanism in SQL Server Instance Recovery
Author(s) -
Aiwu Li
Publication year - 2021
Publication title -
journal of physics conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1952/3/032056
Subject(s) - computer science , rollback , sql server , process (computing) , database , log shipping , transaction log , web log analysis software , operating system , server , database transaction , the internet , web server , internet authentication service , static web page
This paper discusses the mechanism of locating log records by LSN in the process of SQL Server instance recovery; and explains the detailed process of forward and rollback operations, as well as the main contents of log records and the functions of checkpoint in the instance recovery process.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom