• Understood, but why do they have "Terminate users" option for the Standby option?

    From many technical paper, it seems to suggest that even Read-only copy, user will get booted off if you have the "terminate users" option selected.

    Check it out!  It's annoying to have to do the extra step and it's confusing as well. If it was never meant to be there, MS should take that option off... so I can add my extra step myself.

    BTW, I find it extremely useful to have a read only copy of production for reporting purposes.

    We are migrating all our reporting jobs to this standby server.  We log ship every 2 hours. None of our reports run longer than 1 hour anyways...

    --JON

    DBA/OLAP Developer -
    San Francisco, CA