Sunday, 15 January 2017

Boot page in sql server

Page type of Boot page is 13. Boot page will not be available in the secondary data file. We can see the content of this page using the DBCC Page command and some of the values stores in this page are self explanatory. If this page is corrupted for some reason, it is not possible to recover the database using DBCC Checkdb. The page restore also will not help in this situation. The only possible way to recover the database is restore from last good backup. The base metadata about the whole database is stored in this page. If this page is corrupt, checkdb cannot repair this page, and a restore of file number 1 will be needed to recover the database.

To get information about the database boot page, you can execute DBCC PAGE pointing to page 9 in file 1 or DBCC dbinfo [('dbname')], always activating the trace flag 3604 (DBCC TRACEON(3604)).

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts