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


Boot Page


Boot Page

Author
Message
Sugesh Kumar
Sugesh Kumar
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17047 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
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8553 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
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2024 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
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5022 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
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6675 Visits: 1698
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
Mr or Mrs. 500
Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)

Group: General Forum Members
Points: 590 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 (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2972 Visits: 493
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
Mr or Mrs. 500
Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)

Group: General Forum Members
Points: 590 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
Mr or Mrs. 500
Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)

Group: General Forum Members
Points: 590 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
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8553 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