• andrew gothard (4/20/2015)


    It's worth considering. We are going to have a standby on our other site for HA, but we'd need to talk to our licencing bod to see if that would mean licencing that too. I find it unlikely - I mean who wouldn't check a critical component of a core system. Some colleagues are unconvinced.

    If you're talking something like Mirroring or Always On, you can't checkDB the secondary to get any indication of the state of the primary server. That's why I said restore backups.

    Have you tried taking the snapshot and CheckDB that? Even with a 24/7 system, there should be a quieter period of time where you can take that snapshot and see if that will let you run the CheckDB against it.

    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