Share via

SQL Log records and the LOP_FORMAT_PAGE

Mark Gordon 921 Reputation points
2023-12-27T15:47:34.8+00:00

Fellow DBA's

I am curious if all lsn log records go thru LOP_Format_Page or are any of them written directly to disc without going thru LOP_FORMAT_page?

thx

MG

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
0 comments
Accepted answer
  1. Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
    2023-12-27T22:16:18.54+00:00

    Not sure what you mean here. When googling, it seems to me LOP_FORMAT_PAGE is one type of log record, and this post from Paul Randall gives some idea: https://www.sqlskills.com/blogs/paul/the-curious-case-of-too-few-log-records-for-an-offline-index-rebuild/

    Since LOP_FORMAT_PAGE is just one type of log records, I would say that the answer is: No.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.