Automatic Page Repair

Question

Automatic Page Repair

Mike Hays

SSCommitted

Points: 1871
More actions
November 11, 2013 at 8:42 pm

#301084

Comments posted to this topic are about the item Automatic Page Repair
November 12, 2013 at 12:35 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thanks. Straight forward enough of a question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 2

SQLRNNR (11/11/2013)
Thanks. Straight forward enough of a question.

+1

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

New question that needs doing some searching. 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

sqlnaive SSCoach Points: 17437 More actions · Answer 4

Frankly speaking I was not aware of the answer and simply had to track it down using google. The first site i saw gave me the answer. But good informative question. 🙂

steve.jacobs SSCommitted Points: 1830 More actions · Answer 5

steve.jacobs

SSCommitted

Points: 1830

November 12, 2013 at 5:51 am

#1665702

Good question. Definitely a DBA question. +1

Ed Wagner SSC Guru Points: 287024 More actions · Answer 6

I didn't know the answer either and had to research it. I got to learn something today and it's still early. 😀 Thanks for a good question to get my brain moving.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Dana Medley SSCertifiable Points: 6764 More actions · Answer 7

Ed Wagner (11/12/2013)
I didn't know the answer either and had to research it. I got to learn something today and it's still early. 😀 Thanks for a good question to get my brain moving.

+1 Indeed, I definitely learned something today.

Everything is awesome!

jfogel SSCarpal Tunnel Points: 4155 More actions · Answer 8

I got it right not because I actually knew the answer but because I figured that the data (meaning common) pages would be fixed by automatic page repair while more high-end issues would not. The logic being that the more you need it the more likely it wont happen.

Cheers

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 9

Nice question Mike! I love these documented features that are documented in TechNet only copies of the Books Online. 😎

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 10

jfogel (11/12/2013)
I got it right not because I actually knew the answer but because I figured that the data (meaning common) pages would be fixed by automatic page repair while more high-end issues would not. The logic being that the more you need it the more likely it wont happen.

LOL... That is cute but I believe the actual logic is it can only repair the pages to do with the mirrored Data itself and not the copy of the mirrored data.

I.E. - I can request a page that is in the data pages of the mirrored database source, but not anything that is unique to the partner database created to hold the mirrored database.

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Dana Medley (11/12/2013)
Ed Wagner (11/12/2013)
I didn't know the answer either and had to research it. I got to learn something today and it's still early. 😀 Thanks for a good question to get my brain moving.
+1 Indeed, I definitely learned something today.

Me, too. Thanks, Mike!

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 12

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 13

PHYData DBA (11/12/2013)
jfogel (11/12/2013)
I got it right not because I actually knew the answer but because I figured that the data (meaning common) pages would be fixed by automatic page repair while more high-end issues would not. The logic being that the more you need it the more likely it wont happen.
LOL... That is cute but I believe the actual logic is it can only repair the pages to do with the mirrored Data itself and not the copy of the mirrored data.
I.E. - I can request a page that is in the data pages of the mirrored database source, but not anything that is unique to the partner database created to hold the mirrored database.

I guess I agree with PHYData; some pages contain information about physical positioning (ie information about the the physical copy of the data), and since the physical to logical mapping won't be the same for both units those pages won't be recoverable. Other pages contain only logical positioning information, so are the same for all copies of the data: no reason they shouldn't be recoverable. It is of course a natural consequence of Murphy's law that the pages whose loss do the greatest damage are the ones which are not recoverable, but Murphy's law applies to all processes, including the process of making deductions from Murphy's law, and thus jvogel's reasoning doesn't wash.

Tom