Home Forums SQL Server 2016 SQL Server 2016 - Administration Refreshing lower environments with prod copy RE: Refreshing lower environments with prod copy

  • April 23, 2018 at 11:08 am

    #1987921

    Feivel - Monday, April 23, 2018 11:02 AM

    Jeff Moden - Monday, April 23, 2018 9:34 AM

    Get your infrastructure folks to automate SAN snapshots for you.  They're nearly instantaneous.

    Thanks! Jeff. Will this require an outage on the production system or any adverse affects of it?

    Not if it's done correctly.  You need to check the SAN documentation or have your SAN administrator check on it.  Not all SAN manufacturers build in such a capability and it is sometimes an addition "product" that you need to buy but it's usually very well worth it in such cases as what you describe.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)