July 19, 2017 at 8:41 am
After running DBCC CHECKDB I am getting
Found 0 error and repaired 0 errors. Internal database snapshot has split point LSN = 000000de:000001d5:0001 and first LSN = 000000de:000001d4:0001.
It says No User action required.
Can anyone explain me what is LSN split point and do I have to fix it and How??
Regards,
Nita
July 19, 2017 at 9:33 am
No user action is required. There's nothing you need to do there, nothing's broken, nothing needs fixing.
It's an informational message telling you that CheckDB ran and found no errors.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2017 at 11:41 am
DBCC CHECKDB does not run directly on your database. Instead, it creates a snapshot of your database at that point in time when you clicked the button, and runs against that snapshot. If you make any subsequent updates, DBCC checkdb will not check them. When it creates the snapshot, it marks it with the current Log Sequence Number (LSN). Then records its first own LSN.
What I can't explain is why it creates split LSN with a bigger number (d5) than its 1st LSN which is d4.
This all is purely informational message, in case if DBA keeps records of such checks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply