Post reply

Copy existing database to another database

  • April 4, 2007 at 9:50 am

    #68480

    Extreme SQL noob here, working with SQL 2000.  I want to take one existing, functional database and copy it to another database on the same server.

    For example:

    NGPROD is our working database.  NGTEST is our test database.  I want to copy NGPROD to NGTEST.

    If it's a few quick steps, great.  If you can point me to a quickie tutorial, marvelous.

  • April 4, 2007 at 10:41 am

    #698599

    1. Backup NGPROD (or if you have a good backup already, it is not necessary)

    2. Restore  this backup, wherever necessary, with a different name.

  • April 4, 2007 at 3:29 pm

    #698664

    Feeling quite smug.  I actually stumbled upon that process after posting my inquiry.  I do appreciate your response - thanks.

  • April 4, 2007 at 8:09 pm

    #698695

    Some hard disk systems (SAN's, etc) come with clone and snapshot systems that will do this in scant minutes for a half-terabyte database.

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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply