SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Boot Page


Boot Page

Author
Message
Sugesh Kumar
Sugesh Kumar
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8311 Visits: 358
Comments posted to this topic are about the item Boot Page

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Christian Buettner-167247
Christian Buettner-167247
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5135 Visits: 3889
I think the answer is incomplete, the log file also contains the boot page:

One of the system pages stored in both the primary data file and the first log file is a database boot page that contains information about the attributes of the database.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/39e00ebe-c9b7-4d53-90bd-15de2015fd34.htm

Best Regards,

Chris Büttner
dunnjoe
dunnjoe
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1966 Visits: 208
Christian,

I found this very informative web-page that states it is always page 9 in file 1. It goes on to give excellent details on what is on the page.

Joe

http://www.sqlskills.com/blogs/paul/2008/07/11/SearchEngineQA20BootPagesAndBootPageCorruption.aspx
StarNamer
StarNamer
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2684 Visits: 1992
After looking at the reference in the asnwer (the ms-help: ref doesn't work for me) I tried the 'DBCC DBINFO()' statement and just got a message 'DBCC execution completed. If DBCC printed error messages, contact your system administrator.'!

More searching revealed that the command 'dbcc traceon(3604)' was needed as well! Perhaps this should have been mentioned somewhere!

Also a document search for either 'bootpage' or 'boot page' came up with nothing in the 2005 BOL and nothing that I could see that was relevant in MSDN (though I didn't check every MSDN link, just skimmed the intros).

Derek
Miles Neale
Miles Neale
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4174 Visits: 1695
If you are looking for more information on this you might read at

http://www.sqlskills.com/blogs/paul/2008/07/11/SearchEngineQA20BootPagesAndBootPageCorruption.aspx

Miles...

Not all gray hairs are Dinosaurs!
Scott Klein-508332
Scott Klein-508332
SSC-Addicted
SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)

Group: General Forum Members
Points: 492 Visits: 64
I agree. I spent 1/2 hour googling this. I found BOL stuff, stuff on MSDN, but nothing like the information provided in the answer link.
Mark D Powell
Mark D Powell
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2115 Visits: 466
But Booksonline also contains this quote "Log files do not contain pages; they contain a series of log records."

Blame MS not the author or question as I found the same section you did but I also found this

>>
Only database pages can be restored. Page restore cannot be used to restore the following:

Transaction log

Allocation pages—Global Allocation Map (GAM) pages, Shared Global Allocation Map (SGAM) pages, and Page Free Space (PFS) pages. For more information, see Managing Extent Allocations and Free Space.

Page 0 of all data files (the file boot page)

Page 1:9 (the database boot page)

Full-text catalog
<<

MS documentation leaves a lot to be desired.

-- Mark D Powell --
Scott Klein-508332
Scott Klein-508332
SSC-Addicted
SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)

Group: General Forum Members
Points: 492 Visits: 64
True, BOL could be better, but I certainly won't blame anyone but myself for not finding the correct answer. I was probably Googling the wrong term, who knows. Whether I got the question right or wrong, I learned something new today.
Scott Klein-508332
Scott Klein-508332
SSC-Addicted
SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)SSC-Addicted (492 reputation)

Group: General Forum Members
Points: 492 Visits: 64
Actually, I found out what my search error was. I was Googling "bootpage", and not "boot page". If you Google the later, the answer is the first link displayed.
Christian Buettner-167247
Christian Buettner-167247
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5135 Visits: 3889
Christian Buettner (8/21/2008)
I think the answer is incomplete, the log file also contains the boot page:

One of the system pages stored in both the primary data file and the first log file is a database boot page that contains information about the attributes of the database.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/39e00ebe-c9b7-4d53-90bd-15de2015fd34.htm


Here is the MSDN link for those where the BOL link did not work:
http://msdn.microsoft.com/en-us/library/ms179316(SQL.90).aspx

Best Regards,

Chris Büttner
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search