Home Forums SQL Server 2008 SQL Server 2008 - General Keeping all three environment(Dev,Stag,Prod) in sync RE: Keeping all three environment(Dev,Stag,Prod) in sync

  • December 28, 2012 at 8:40 pm

    #1572288

    wannalearn (12/27/2012)

    Thank you all for your responses.

    We can not use Log Shipping because Our databases do not store transactions. We load data everynight from different sources . So it is not our responsibility right now.

    We use replication but only for some database. My senior DBA has not kept all databases in sync for some reason. it could be hardware issues.

    This is exactly what we want as mentioned by @SQLFRNDZ - "his requirement is not DR and he just wants to copy a database to other lower environments daily and want to automate the process."

    Is there any efficient way other than back up and restore ?

    Thanks!

    Yep... like I said, use the SAN replication if available. DR isn't it's only use. It's very handy and lightning fast at keeping databases in sync.

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