• On a couple of our QA servers, we have daily jobs that will detach the database, copy a drive via SAN specific commands, then reattach the newly copied database. SAN copies are much faster than copying via windows.

    We also run a few other processes after wards to get our QA users permissioned.

    Basically automated data refreshes for DEV and QA. Hope the idea helps.

    Jason Carter
    Tampa, Florida

    "Anyone who stops learning is old, whether at twenty or eighty. Anyone who keeps learning stays young. The greatest thing in life is to keep your mind young" - Henry Ford