USE master
GO

-- create database to use
IF DATABASEPROPERTYEX(N'testDB', N'Version') > 0
BEGIN
	ALTER DATABASE [testDB]

	SET single_user
	WITH

	ROLLBACK immediate;

	DROP DATABASE [testDB];
END
GO

CREATE DATABASE [testDB] ON PRIMARY (
	name = N'testDB_data',
	filename = N'D:\Documents\MSSQL\DATA\testDB_data.mdf'
	) log ON (
	name = N'testDB_log',
	filename = N'D:\Documents\MSSQL\LOG\testDB_log.ldf',
	size = 5 MB,
	filegrowth = 1 MB
	);
GO

-- set the database in SIMPLE recovery model & disable automatic 
-- statistics to minimize any other tlog records
ALTER DATABASE [testDB]

SET recovery SIMPLE;
GO

ALTER DATABASE [testDB]

SET auto_create_statistics OFF;
GO

USE testDB;
GO

SET NOCOUNT ON;
GO

--=======================================================
-- DEMO #1: Analyzing the transaction log
-- 3) Look at the contents of the tlog
-- Graphic explaining this better: http://bit.ly/Uu46Mw
--=======================================================
DBCC loginfo;
GO

-- 4) Create a table that will generate large amount of tlog records
CREATE TABLE [testTable] (
	[c1] INT identity,
	[c2] CHAR(8000) DEFAULT 'This is a record'
	)
GO

-- 5) Insert rows to fill all of the VLFs
INSERT INTO [testTable] DEFAULT
VALUES;GO 400

-- 6) Look at the contents of the tlog after filling the first two VLFs
DBCC loginfo;
GO

--RecoveryUnitId	FileId	FileSize	StartOffset	FSeqNo	Status	Parity	CreateLSN
--0					2		1245184		8192		45		2		64		0
--0					2		1245184		1253376		46		2		64		0
--0					2		1245184		2498560		47		2		64		0
--0					2		1499136		3743744		48		2		64		0
-- 7) Start an explicit transaction in a different windows
-- Keep it open to hold a VLF active
--use testDB
--go
--begin tran
--insert into [testTable] default values;
--go
----
--commit tran
-- 8) force checkpoint to clear the first three VLFs
-- Depending on the background task, the first three
-- VLFs may have already been cleared out by the
-- earlier CHECKPOINT process so this may just clear
-- out the third VLF
CHECKPOINT
GO

-- 9) Look at the contents of the tlog after the checkpoint
DBCC loginfo;
GO

--RecoveryUnitId	FileId	FileSize	StartOffset	FSeqNo	Status	Parity	CreateLSN
--0					2		1245184		8192		45		0		64		0
--0					2		1245184		1253376		46		0		64		0
--0					2		1245184		2498560		47		0		64		0
--0					2		1499136		3743744		48		2		64		0
-- 10) Add more rows to fill up the 4th VLF
-- See how the circular bature of the log works
INSERT INTO [testTable] DEFAULT
VALUES;GO 400

--=======================================================
-- DEMO #2: Circular nature of the transaction log
-- 11) Look at the contents of the tlog after circling 
-- back to the first 2 VLFs
--=======================================================
DBCC loginfo;
GO

--RecoveryUnitId	FileId	FileSize	StartOffset	FSeqNo	Status	Parity	CreateLSN
--0					2		1245184		8192		49		2		128		0
--0					2		1245184		1253376		50		2		128		0
--0					2		1245184		2498560		47		0		64		0
--0					2		1499136		3743744		48		2		64		0
-- Add even more rows to auto-grow the tlog
INSERT INTO [testTable] DEFAULT
VALUES;GO 400

--RecoveryUnitId	FileId	FileSize	StartOffset	FSeqNo	Status	Parity	CreateLSN
--0					2		1245184		8192		49		2		128		0
--0					2		1245184		1253376		50		2		128		0
--0					2		1245184		2498560		51		2		128		0
--0					2		1499136		3743744		48		2		64		0
--0					2		253952		5242880		52		2		64		51000000190000006
--0					2		253952		5496832		53		2		64		51000000190000006
--0					2		253952		5750784		54		2		64		51000000190000006
--0					2		286720		6004736		55		2		64		51000000190000006
--0					2		253952		6291456		56		2		64		54000000045000006
--0					2		253952		6545408		57		2		64		54000000045000006
--0					2		253952		6799360		58		2		64		54000000045000006
--0					2		286720		7053312		59		2		64		54000000045000006
--0					2		253952		7340032		60		2		64		58000000044900004
--0					2		253952		7593984		61		2		64		58000000044900004
--0					2		253952		7847936		0		0		0		58000000044900004
--0					2		286720		8101888		0		0		0		58000000044900004
-- 12) Add some more rows but keep a transaction open. This will cause the log to grow
-- because a VLF is held by the active transaction
INSERT INTO [testTable] DEFAULT
VALUES;GO 300

-- 13) Look at the contents of the tlog after growing
DBCC loginfo;
GO

--RecoveryUnitId	FileId	FileSize	StartOffset	FSeqNo	Status	Parity	CreateLSN
--0					2	    1245184		8192	    65		2	    64	      0
--0					2	    1245184		1253376		50		0	    128	      0
--0					2	    1245184		2498560	    51	    0	    128	      0
--0					2	    1499136		3743744	    64	    2	    128	      0
--0					2	    253952		5242880	    52	    0	    64	      51000000190000006
--0					2	    253952		5496832	    53	    0	    64	      51000000190000006
--0					2	    253952		5750784	    54	    0	    64	      51000000190000006
--0					2	    286720		6004736	    55	    0	    64	      51000000190000006
--0					2	    253952		6291456	    56	    0	    64	      54000000045000006
--0					2	    253952		6545408	    57	    0	    64	      54000000045000006
--0					2	    253952		6799360	    58	    0	    64	      54000000045000006
--0					2	    286720		7053312	    59	    0	    64	      54000000045000006
--0					2	    253952		7340032	    60	    0	    64	      58000000044900004
--0					2	    253952		7593984	    61	    2	    64	      58000000044900004
--0					2	    253952		7847936		62	    2	    64	      58000000044900004
--0					2	    286720		8101888		63	    2	    64	      58000000044900004
-- 14) run checkpoint to see if the log truncates
CHECKPOINT;
GO

-- 15) check the amount of log used
DBCC SQLPERF (logspace);
GO

--Database Name	Log Size (MB)	Log Space Used (%)	Status
--testDB		7,992188		76,03861			0
--=======================================================
-- DEMO #3: clearing/truncating the transaction log
-- 16) Release the active transaction
--=======================================================
-- 17) Look at the contents of the tlog after releasing the transaction
DBCC loginfo;
GO

-- 18) check the amount of log used
DBCC SQLPERF (logspace);
GO

--Database Name	Log Size (MB)	Log Space Used (%)	Status
--testDB		7,992188		75,89809			0
-- Why did it drop?
-- Log space reservation!
-- Run checkpoint to see if the log truncates
CHECKPOINT;
GO

-- 29) Look at the contents of the tlog after runnng checkpoint
DBCC loginfo;
GO

--RecoveryUnitId	FileId	FileSize	StartOffset	FSeqNo	Status	Parity	CreateLSN
--0					2		1245184		8192		65		0		64		0
--0					2		1245184		1253376		66		0		64		0
--0					2		1245184		2498560		67		2		64		0
--0					2		1499136		3743744		64		0		128		0
--0					2		253952		5242880		52		0		64		51000000190000006
--0					2		253952		5496832		53		0		64		51000000190000006
--0					2		253952		5750784		54		0		64		51000000190000006
--0					2		286720		6004736		55		0		64		51000000190000006
--0					2		253952		6291456		56		0		64		54000000045000006
--0					2		253952		6545408		57		0		64		54000000045000006
--0					2		253952		6799360		58		0		64		54000000045000006
--0					2		286720		7053312		59		0		64		54000000045000006
--0					2		253952		7340032		60		0		64		58000000044900004
--0					2		253952		7593984		61		0		64		58000000044900004
--0					2		253952		7847936		62		0		64		58000000044900004
--0					2		286720		8101888		63		0		64		58000000044900004
DBCC SQLPERF (logspace);
GO

--Database Name	Log Size (MB)	Log Space Used (%)	Status
--testDB		7,992188		21,17546			0
-- 20) To really dig into the internals of the transaction log
--     we can use the undocumented function fn_dblog()
-- 1) Create database to use
USE master
GO

IF DATABASEPROPERTYEX(N'testDb2', N'Version') > 0
BEGIN
	ALTER DATABASE [testDb2]

	SET single_user
	WITH

	ROLLBACK immediate

	DROP DATABASE [testDB2]
END
GO

CREATE DATABASE [testDB2] ON PRIMARY (
	name = N'testDB2_data',
	filename = N'D:\Documents\MSSQL\DATA\testDB2_data.mdf'
	) log ON (
	name = N'testDB2_log',
	filename = N'D:\Documents\MSSQL\LOG\testDB2_log.ldf',
	size = 5 MB,
	filegrowth = 1 MB
	);
GO

ALTER DATABASE [testDB2]

SET recovery SIMPLE;
GO

ALTER DATABASE [testDB2]

SET auto_create_statistics OFF;
GO

USE testDB2
GO

CHECKPOINT;
GO

/* DO NOT USE IN PRODUCTION !!! */
SELECT Description,
	*
FROM fn_dblog(NULL, NULL);
GO

--Description	Current LSN	Operation	Context	Transaction ID	LogBlockGeneration	Tag Bits	Log Record Fixed Length	Log Record Length	Previous LSN	Flag Bits	Log Reserve	AllocUnitId	AllocUnitName	Page ID	Slot ID	Previous Page LSN	PartitionId	RowFlags	Num Elements	Offset in Row	Modify Size	Checkpoint Begin	CHKPT Begin DB Version	Max XDESID	Num Transactions	Checkpoint End	CHKPT End DB Version	Minimum LSN	Dirty Pages	Oldest Replicated Begin LSN	Next Replicated End LSN	Last Distributed Backup End LSN	Last Distributed End LSN	Repl Min Hold LSN	Server UID	SPID	Beginlog Status	Xact Type	Begin Time	Transaction Name	Transaction SID	Parent Transaction ID	Oldest Active Transaction ID	Xact ID	Xact Node ID	Xact Node Local ID	End AGE	End Time	Transaction Begin	Replicated Records	Oldest Active LSN	Server Name	Database Name	Mark Name	Repl Partition ID	Repl Epoch	Repl CSN	Repl Flags	Repl Msg	Repl Source Commit Time	Master XDESID	Master DBID	Preplog Begin LSN	Prepare Time	Virtual Clock	Previous Savepoint	Savepoint Name	Rowbits First Bit	Rowbits Bit Count	Rowbits Bit Value	Number of Locks	Lock Information	LSN before writes	Pages Written	Command Type	Publication ID	Article ID	Partial Status	Command	Byte Offset	New Value	Old Value	New Split Page	Rows Deleted	Bytes Freed	CI Table Id	CI Index Id	NewAllocUnitId	FileGroup ID	Meta Status	File Status	File ID	Physical Name	Logical Name	Format LSN	RowsetId	TextPtr	Column Offset	Flags	Text Size	Offset	Old Size	New Size	Description	Bulk allocated extent count	Bulk RowsetId	Bulk AllocUnitId	Bulk allocation first IAM Page ID	Bulk allocated extent ids	VLFs added	InvalidateCache Id	InvalidateCache keys	CopyVerionInfo Source Page Id	CopyVerionInfo Source Page LSN	CopyVerionInfo Source Slot Id	CopyVerionInfo Source Slot Count	RowLog Contents 0	RowLog Contents 1	RowLog Contents 2	RowLog Contents 3	RowLog Contents 4	RowLog Contents 5	Compression Log Type	Compression Info	PageFormat PageType	PageFormat PageFlags	PageFormat PageLevel	PageFormat PageStat	PageFormat FormatOption	Log Record
--2020/02/26 12:19:46:770	0000002d:000000b3:0040	LOP_BEGIN_CKPT	LCX_NULL	0000:00000000	0	0x0000	96	96	0000002d:00000030:00b4	0x0000	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:19:46:770	869	0000:00003303	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:19:46:770	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x000060002D00000030000000B40000000000000000009600BF2FCB006DAB000000000000000000000000650303330000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--	0000002d:000000ce:0001	LOP_XACT_CKPT	LCX_BOOT_PAGE_CKPT	0000:00000000	0	0x0000	24	28	00000000:00000000:0000	0x0000	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x00001800000000000000000000000000000000000000981700000000
--2020/02/26 12:19:46:773;log_minRecoveryLsn 0000002d:000000b3:0040;log_replbeginlsn 00000000:00000000:0000;log_replnextlsn 00000000:00000000:0000;log_distbackuplsn 00000000:00000000:0000;log_distlastlsn 00000000:00000000:0000	0000002d:000000cf:0001	LOP_END_CKPT	LCX_NULL	0000:00000000	0	0x0000	136	136	0000002d:000000b3:0040	0x0000	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:19:46:773	869	0000002d:000000b3:0040	0	00000000:00000000:0000	00000000:00000000:0000	00000000:00000000:0000	00000000:00000000:0000	00000000:00000000:0000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:19:46:773;log_minRecoveryLsn 0000002d:000000b3:0040;log_replbeginlsn 00000000:00000000:0000;log_replnextlsn 00000000:00000000:0000;log_distbackuplsn 00000000:00000000:0000;log_distlastlsn 00000000:00000000:0000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x000088002D000000B3000000400000000000000000009900C02FCB006DAB00002D000000B3000000400065030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
CHECKPOINT;
GO

BACKUP DATABASE [testDB2] TO DISK = 'D:\Documents\MSSQL\BACKUP\testDB2.bak'
WITH init,
	stats
GO

/* RATHER USE THE FUNCTION: FN_DUMP_DBLOG() */
SELECT *
FROM fn_dump_dblog(DEFAULT, DEFAULT, DEFAULT, DEFAULT, 'D:\Documents\MSSQL\BACKUP\testDB2.bak', DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
GO

--Current LSN				Operation				Context				Transaction ID	LogBlockGeneration	Tag Bits	Log Record Fixed Length	Log Record Length	Previous LSN			Flag Bits	Log Reserve	AllocUnitId	AllocUnitName	Page ID	Slot ID	Previous Page LSN	PartitionId	RowFlags	Num Elements	Offset in Row	Modify Size	Checkpoint Begin	CHKPT Begin DB Version	Max XDESID	Num Transactions	Checkpoint End	CHKPT End DB Version	Minimum LSN	Dirty Pages	Oldest Replicated Begin LSN	Next Replicated End LSN	Last Distributed Backup End LSN	Last Distributed End LSN	Repl Min Hold LSN	Server UID	SPID	Beginlog Status	Xact Type	Begin Time	Transaction Name	Transaction SID	Parent Transaction ID	Oldest Active Transaction ID	Xact ID	Xact Node ID	Xact Node Local ID	End AGE	End Time	Transaction Begin	Replicated Records	Oldest Active LSN	Server Name	Database Name	Mark Name	Repl Partition ID	Repl Epoch	Repl CSN	Repl Flags	Repl Msg	Repl Source Commit Time	Master XDESID	Master DBID	Preplog Begin LSN	Prepare Time	Virtual Clock	Previous Savepoint	Savepoint Name	Rowbits First Bit	Rowbits Bit Count	Rowbits Bit Value	Number of Locks	Lock Information	LSN before writes	Pages Written	Command Type	Publication ID	Article ID	Partial Status	Command	Byte Offset	New Value	Old Value	New Split Page	Rows Deleted	Bytes Freed	CI Table Id	CI Index Id	NewAllocUnitId	FileGroup ID	Meta Status	File Status	File ID	Physical Name	Logical Name	Format LSN	RowsetId	TextPtr	Column Offset	Flags	Text Size	Offset	Old Size	New Size	Description	Bulk allocated extent count	Bulk RowsetId	Bulk AllocUnitId	Bulk allocation first IAM Page ID	Bulk allocated extent ids	VLFs added	InvalidateCache Id	InvalidateCache keys	CopyVerionInfo Source Page Id	CopyVerionInfo Source Page LSN	CopyVerionInfo Source Slot Id	CopyVerionInfo Source Slot Count	RowLog Contents 0	RowLog Contents 1	RowLog Contents 2	RowLog Contents 3	RowLog Contents 4	RowLog Contents 5	Compression Log Type	Compression Info	PageFormat PageType	PageFormat PageFlags	PageFormat PageLevel	PageFormat PageStat	PageFormat FormatOption	Log Record
--0000002d:000000d2:0001	LOP_CLEAR_GAM_BITS		LCX_DIFF_MAP		0000:00000000	0					0x0000		62						100					00000000:00000000:0000	0x0000		0	6488064		0001:00000006	1	0000002d:00000088:0033	0	0	6	0	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x04000400	0x0600	0x	0x	0x6F9DFF55D00300000300000000000000	0x0300000000000000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x00003E0000000000000000000000000000000000000011180600000001000100630000002D00000088000000330000000000000000000000000000000000060004000200000000000600060004000400060000006F9DFF55D00300000300000000000000
--0000002d:000000d2:0002	LOP_SET_BITS			LCX_DIFF_MAP		0000:00000000	0					0x0000		54						56					00000000:00000000:0000	0x0000		0	6488064		0001:00000006	1	0000002d:000000d2:0001	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	34	1	0x01	0		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	SetBit 0001:00000010	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000360000000000000000000000000000000000000007180600000001000100630000002D000000D2000000010000002200010001000000
--0000002d:000000d2:0003	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	458752		0001:00000014	13	0000002d:000000b3:003e	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 0 (HOBTCOUNT) on rowset 281474978283520. Leaf page count: 1, Reserved page count: 2, Used page count: 2	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012021400000001000D00070000002D000000B30000003E00000000000000000000000000180000000100000000000000000000000000000000000100000000000000350000000800000002000000000000002D0000000800000002000000000000003D000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:0004	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	327680		0001:00000011	13	0000002d:000000b3:0035	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 1 (ROWSETCOUNT) on rowset 281474978283520. Row count: 2.	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012021100000001000D00050000002D000000B300000035000000010000000000000000001800000001000000000000000000000000000000000002000000000000001F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:0005	LOP_SET_BITS			LCX_DIFF_MAP		0000:00000000	0					0x0000		54						56					00000000:00000000:0000	0x0000		0	6488064		0001:00000006	1	0000002d:000000d2:0002	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	40	1	0x01	0		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	SetBit 0001:00000040	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000360000000000000000000000000000000000000007180600000001000100630000002D000000D2000000020000002800010001000000
--0000002d:000000d2:0006	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	196608		0001:00000041	82	0000002d:00000030:0067	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 2 (ROWSETCOLUMNCOUNT) on rowset 281474978283520. Column Id: 1, mod count: 6	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012024100000001005200030000002D000000300000006700000002000000000000000000180000000100000000000000000000000000000000000100000000000000060000000000000014000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:0007	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	196608		0001:00000041	83	0000002d:000000d2:0006	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 2 (ROWSETCOLUMNCOUNT) on rowset 281474978283520. Column Id: 2, mod count: 6	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012024100000001005300030000002D000000D20000000600000002000000000000000000180000000100000000000000000000000000000000000200000000000000060000000000000014000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:0008	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	196608		0001:00000041	84	0000002d:000000d2:0007	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 2 (ROWSETCOLUMNCOUNT) on rowset 281474978283520. Column Id: 3, mod count: 14	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012024100000001005400030000002D000000D200000007000000020000000000000000001800000001000000000000000000000000000000000003000000000000000E0000000000000014000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:0009	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	196608		0001:00000041	85	0000002d:000000d2:0008	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 2 (ROWSETCOLUMNCOUNT) on rowset 281474978283520. Column Id: 4, mod count: 16	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012024100000001005500030000002D000000D20000000800000002000000000000000000180000000100000000000000000000000000000000000400000000000000100000000000000014000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:000a	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	196608		0001:00000041	86	0000002d:000000d2:0009	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 2 (ROWSETCOLUMNCOUNT) on rowset 281474978283520. Column Id: 5, mod count: 16	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012024100000001005600030000002D000000D20000000900000002000000000000000000180000000100000000000000000000000000000000000500000000000000100000000000000014000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:000b	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	196608		0001:00000041	87	0000002d:000000d2:000a	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 2 (ROWSETCOLUMNCOUNT) on rowset 281474978283520. Column Id: 6, mod count: 16	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012024100000001005700030000002D000000D20000000A00000002000000000000000000180000000100000000000000000000000000000000000600000000000000100000000000000014000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:000c	LOP_COUNT_DELTA			LCX_CLUSTERED		0000:00000000	0					0x0000		208						208					00000000:00000000:0000	0x0000		0	196608		0001:00000041	88	0000002d:000000d2:000b	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Action 2 (ROWSETCOLUMNCOUNT) on rowset 281474978283520. Column Id: 7, mod count: 20	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x0000D00000000000000000000000000000000000000012024100000001005800030000002D000000D20000000B00000002000000000000000000180000000100000000000000000000000000000000000700000000000000140000000000000014000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000d2:0025	LOP_BEGIN_CKPT			LCX_NULL			0000:00000000	0					0x0000		96						96					0000002d:000000b3:0040	0x0000		0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:22:10:013	869	0000:00003304	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:22:10:013	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x000060002D000000B30000004000000000000000000096009CD7CB006DAB000000000000000000000000650304330000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
--0000002d:000000e1:0001	LOP_XACT_CKPT			LCX_BOOT_PAGE_CKPT	0000:00000000	0					0x0000		24						28					00000000:00000000:0000	0x0000		0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x00001800000000000000000000000000000000000000981700000000
--0000002d:000000e2:0001	LOP_END_CKPT			LCX_NULL			0000:00000000	0					0x0000		136						136					0000002d:000000d2:0025	0x0000		0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:22:10:017	869	0000002d:000000d2:0025	0	00000000:00000000:0000	00000000:00000000:0000	00000000:00000000:0000	00000000:00000000:0000	00000000:00000000:0000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2020/02/26 12:22:10:017;log_minRecoveryLsn 0000002d:000000d2:0025;log_replbeginlsn 00000000:00000000:0000;log_replnextlsn 00000000:00000000:0000;log_distbackuplsn 00000000:00000000:0000;log_distlastlsn 00000000:00000000:0000	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0x000088002D000000D20000002500000000000000000099009DD7CB006DAB00002D000000D2000000250065030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000