Home Forums SQLServerCentral.com Editorials The Backup Process RE: The Backup Process

  • March 17, 2013 at 3:32 pm

    #1597920

    I actually do a restore from prod to UAT every night for two purposes. 1) Test the backup and 2) Keep the UAT database up to snuff. Yes... if they have any new objects that aren't in prod, they'll be blown away so there's actually a 3rd reason... test and retest the code/object promotio scripts.

    --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)