Using the fn_dblog I can get the active portion of the online transaction log of my database. But after every checkpoint I can only see 2 entries showing the beginning of the checkpoint ...
I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this: And the details of the selected event are: The ...
This seems like a fairly common scenario, yet I'm not sure how to do this. I have a very large database (think a lot of terabytes), which makes it impossible to create a full backup. At some point, I ...