Post reply

Page Repair

  • April 11, 2011 at 10:21 pm

    #235495

    Comments posted to this topic are about the item Page Repair

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • April 11, 2011 at 10:27 pm

    #1310200

    Nice question Ron!

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • April 12, 2011 at 12:22 am

    #1310219

    Great question, thanks.

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

  • April 12, 2011 at 12:42 am

    #1310220

    Very good Q. I learnt some new stuff.

  • April 12, 2011 at 3:22 am

    #1310261

    Great question! It seems that some of the learning I did for the 70-432 stuck in my head too which is nice 😀

  • April 12, 2011 at 3:33 am

    #1310267

    Great question, and I've learned something new. Mind you there is much involved with SQL that it be hard not to. 🙂

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • April 12, 2011 at 4:38 am

    This was removed by the editor as SPAM

  • April 12, 2011 at 6:29 am

    #1310318

    Thanks for the question.

    M&M

  • April 12, 2011 at 6:44 am

    #1310330

    Thanks for the question

  • April 12, 2011 at 6:50 am

    #1310333

    Good question.

    I didn't realise 829 errors caused it as well, so I've leart something new.

    Tom

  • April 12, 2011 at 9:25 am

    #1310465

    Process of elimination. It said 'pick 3', so I looked for the two that can't be single-page restored.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 12, 2011 at 9:59 am

    #1310486

    Nice question, thanks! This is also a nice feature, though it is best if you don't have corrupt pages that need fixing. 😉

  • April 12, 2011 at 10:05 am

    #1310492

    Like GilaMonster, I did it backwards, and looked for the two that wouldn't work.

    Paul Randal just tweeted that DBCC CHECKDB will trigger it as well.

  • April 12, 2011 at 10:46 am

    #1310518

    Excellent question. This is a question that should be helpful to many database professionals.

    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

  • April 12, 2011 at 11:55 am

    #1310571

    GilaMonster (4/12/2011)

    Process of elimination. It said 'pick 3', so I looked for the two that can't be single-page restored.

    If only I'd had the brains to notice it said "pick 3" - sloppy reading again :ermm:

    Tom

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

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