|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Friday, October 23, 2009 7:16 AM
Points: 3,461,
Visits: 287
|
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 12:28 AM
Points: 1,369,
Visits: 2,120
|
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Thursday, July 02, 2009 4:05 AM
Points: 1,583,
Visits: 133
|
|
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
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, October 06, 2009 11:08 AM
Points: 1,095,
Visits: 1,758
|
|
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
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Thursday, October 22, 2009 4:54 PM
Points: 963,
Visits: 205
|
|
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!
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, January 27, 2009 10:09 PM
Points: 414,
Visits: 60
|
|
| 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.
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Tuesday, November 17, 2009 12:05 PM
Points: 648,
Visits: 176
|
|
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 --
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, January 27, 2009 10:09 PM
Points: 414,
Visits: 60
|
|
| 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.
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, January 27, 2009 10:09 PM
Points: 414,
Visits: 60
|
|
| 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.
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 12:28 AM
Points: 1,369,
Visits: 2,120
|
|
|
|
|
