Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Boot Page


Boot Page

Author
Message
Christian Buettner-167247
Christian Buettner-167247
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2949 Visits: 3889
Mark D Powell (8/21/2008)
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


Hi Mark, I am not blaming the author, just wanted to note that the log also stores the boot page.
Just for additional confusion, check this info from BOL:
The format of log records and pages is not constrained to follow the format of data pages.
http://msdn.microsoft.com/en-us/library/ms190925(SQL.90).aspx

I "think" that the info from your quote is incorrect (but of course correctly quoted from BOL).
It might be possible that the log contains both, pages for the header information, and log records for the log data. Or maybe the log reords are actually stored in pages as well.

But MS only knows ;-)

Best Regards,

Chris Büttner
Anipaul
Anipaul
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6275 Visits: 1407
Thanks guys, I learnt something new from your links...



Mark D Powell
Mark D Powell
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1667 Visits: 457
I think the problem is the first quote should really say "data pages". I do not think the internal format of the log uses "pages" but rather places the data, copy of pages, into log records. The line you reference about not having to use the data page format hints that the original format is not maintained hence the logs do not contain pages. Yet, you can find the term used in the manuals.

The real problem is terminology. Page and block are often used as synonyms Really, a page should refer to the size of the IO used in OS page sets and the term should not be used to describe the database logical structure size or IO block size. But the technical writers have a bad habit of intermixing terms and leaving out qualifying adjectives that would be very beneficial to us mere users of the software.

The Oracle manuals are not much different though the database itself does offer a log more visibility into its internal structures

We live and learn (hopefully).

-- Mark D Powell --
TomThomson
TomThomson
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10656 Visits: 11990
The somewhat contradictory MS documentation is a bit of a mess. Anyway, it seems clear that if you lose File 1 page 9 in a mirrored database you can't even recover that page from the mirror http://msdn.microsoft.com/en-us/library/bb677167.aspx using the built-in recovery mechanism included in mirroring, no can you recover it by any other shortcut means - your database is dead until full recovery is done by one means or another (effectively blowing the whoe database away and recovering it from backups or with snapshot replication from a working copy or some equivalent equivalent mechanism) - at least I'm not aware of any means of recovering that page from the log file, so even though it appears that there is a copy in the log file it doesn't seem to be very useful (I suppose you might be able to do something with a physical level disc editor, but that's way outside the scope of SQL).

Tom

scottm30
scottm30
Say Hey Kid
Say Hey Kid (673 reputation)Say Hey Kid (673 reputation)Say Hey Kid (673 reputation)Say Hey Kid (673 reputation)Say Hey Kid (673 reputation)Say Hey Kid (673 reputation)Say Hey Kid (673 reputation)Say Hey Kid (673 reputation)

Group: General Forum Members
Points: 673 Visits: 383
Great question considering 64% of the answers were incorrect! I came across this issue a short while ago which jogged my memory for this question, but nice to know. Thanks
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