BDBID in DBCC PAGE command output in SQL Server
0
votes
1
answer
173
views
There is a famous undocumented DBCC PAGE command in SQL Server (as well as in SAP ASE) which if successful sends output to errorlog.
Noticed that it has 4 main sections: Buffer, Page Header, Data, and Offset Table.
The question is we notice dbid in the Page Header section.
Similarly, there is a bdbid in the buffer section.
Can we unquestionably say that both these ids will be the same? If anyone has experience around these.
For reference: https://techcommunity.microsoft.com/t5/sql-server/how-to-use-dbcc-page/ba-p/383094 https://www.itprotoday.com/sql-server/using-dbcc-page
Asked by Sonali Gupta
(99 rep)
Feb 25, 2021, 09:45 AM
Last activity: Feb 25, 2021, 10:28 AM
Last activity: Feb 25, 2021, 10:28 AM