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.