Each record in the transaction log is identified by an origin queue ID that consists of 64 hexadecimal characters (32 bytes). The format of the origin queue ID is determined by the Mirror Replication Agent instance, and it varies according to the primary database type.
Table 1-1 illustrates the format of the origin queue ID for the Mirror Replication Agent for Microsoft SQL Server.
Character |
Bytes |
Description |
---|---|---|
0-3 |
2 |
Database generation ID |
4-11 |
4 |
Virtual file sequence number |
12-19 |
4 |
Page start offset |
20-23 |
2 |
Operation number |
24-31 |
4 |
Available for specifying uniqueness |
32-39 |
4 |
Oldest active transaction: virtual file sequence number |
40-47 |
4 |
Oldest active transaction: page start offset |
48-51 |
2 |
Oldest active transaction: operation number |
52-59 |
4 |
Latest committed transaction: page start offset |
60-63 |
2 |
Latest committed transaction: operation number |