Jul 26, 2020

Pages in Database

Boot Page


Every DB has only one boot page. Boot page stores DB configuration information. It can find in page # 9 of the first DB data file.




Bulk Changed Map (BCM) Page


BCM page keep track of the extends which has modified by bulked-logged operations. Log backup thread reads this page and get the extends info and put it in log backup.


Every 6400 extends there will be a BCM page.

No comments:

Post a Comment

If you have any doubt or question, please contact us.