Home Forums SQL Server 2005 Development How to copy production DB into New Developmant Database? RE: How to copy production DB into New Developmant Database?

  • November 3, 2012 at 11:27 am

    #1555781

    poratips (11/3/2012)

    Thanks so much for your prompt response.

    We are taking back up - differential back up daily and during week end we take full back up.

    We have 4-6 DB on one server and couple of them kind of Data Warehousing (Dimensional and Fact Table).

    We don't have that much sensitive data and we have only couple developers.

    Could you please let me know that i am taking correct steps?

    1) Will install Sql server 2008 R2 on new server

    2) Copy latest back up files for all the databases into new server

    3) Restored one by one database backup into new server

    4) Collect login script from source server and run into target server to handle orphan logins

    5) Run DBCC check command to verify the restore

    I am planning use SSMS, will be ok, right?

    Regards,

    That sounds about right. You might run into the occasional problem with a SID for a user or login being out of sync but that's the exception rather than the rule in light of your Step 4.

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