Auto Page Recovery with DB Mirroring

Question

Post reply

Auto Page Recovery with DB Mirroring

chrisfradenburg

SSCrazy Eights

Points: 9592
More actions
August 17, 2011 at 10:42 pm

#241790

Comments posted to this topic are about the item Auto Page Recovery with DB Mirroring
August 18, 2011 at 12:46 am

This was removed by the editor as SPAM

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

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

vk-kirov SSCertifiable Points: 7686 More actions · Answer 1

Nice question.

There is a typo in the answers - "Page Free Spage" should be read as "Page Free Space".

M&M SSC-Insane Points: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

August 18, 2011 at 12:03 am

#1369946

Good question, Thanks.

M&M

TomThomson SSC Guru Points: 104773 More actions · Answer 3

Good question, good clear answer.

Rather a lot (60%) of people getting it wrong, surprisingly.

Tom

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 4

Excellent question. Learned something new today.

http://brittcluff.blogspot.com/

Thomas Abraham SSChampion Points: 10761 More actions · Answer 5

Good question. I agree with Tom. Surprising number of incorrect answers. And yet no complaints - yet. Strange.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 6

Tom.Thomson (8/18/2011)
...
Rather a lot (60%) of people getting it wrong, surprisingly.

I'm surprised that more people didn't get it wrong - especially if, like me, they attempt to answer without looking it up. I wasn't at all surprised to get it wrong - it doesn't strike me as the kind of thing you just know or can work out. I made an educated guess and got one right.

John

Rich Weissler Hall of Fame Points: 3286 More actions · Answer 7

*sob* I read the question backwards... that is, "Which types of pages can be auto recovered..." I remember thinkings, wow... there must be a whole lot that can't be auto-recovered. Index pages aren't a problem, and I know PFS and GAM aren't. Hmmm... well, logically which two would most critically need to be recovered.

Doh! >< I must read the questions closer before answering.

I have to assume the 12% of people who also answered "Data" MUST have read it the same way. 🙂 (I will HAVE to choose to assume they read it that way...)

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 8

Daniel Bowlin

SSC-Dedicated

Points: 34566

August 18, 2011 at 6:55 am

#1370089

Thanks, good question

skrilla99 SSCertifiable Points: 5795 More actions · Answer 9

skrilla99

SSCertifiable

Points: 5795

August 18, 2011 at 7:40 am

#1370118

Nice question! Thanks!

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

Great question, thanks!

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Woot - nice 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

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 12

nice question!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

SanDroid SSChampion Points: 10068 More actions · Answer 13

Great question. I am also a little suprised at the 60% wrong answers rate. Although I understand why some would have selected all of the Allocation Page types. 😎