Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Boot Page Expand / Collapse
Author
Message
Posted Wednesday, August 20, 2008 8:32 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:39 AM
Points: 3,461, Visits: 350
Comments posted to this topic are about the item Boot Page

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Post #556232
Posted Thursday, August 21, 2008 6:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 2,840, Visits: 3,867
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
Post #556440
Posted Thursday, August 21, 2008 8:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, March 31, 2011 1:40 AM
Points: 1,938, 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
Post #556634
Posted Thursday, August 21, 2008 8:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 7:14 AM
Points: 1,344, Visits: 1,983
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
Post #556643
Posted Thursday, August 21, 2008 9:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 7, 2014 3:34 PM
Points: 2,282, Visits: 1,341
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!
Post #556701
Posted Thursday, August 21, 2008 9:39 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, December 18, 2010 3:45 PM
Points: 414, 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.
Post #556702
Posted Thursday, August 21, 2008 11:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:06 PM
Points: 1,368, Visits: 382
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 --

Post #556765
Posted Thursday, August 21, 2008 12:52 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, December 18, 2010 3:45 PM
Points: 414, 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.
Post #556846
Posted Thursday, August 21, 2008 12:55 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, December 18, 2010 3:45 PM
Points: 414, 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.
Post #556850
Posted Thursday, August 21, 2008 5:29 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 2,840, Visits: 3,867
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
Post #556989
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse