Post reply

copy database onto same server

  • November 1, 2004 at 8:18 am

    #109610

    I want to create a copy of an existing database (for development purposes) on the same server as the original database.  I am unable to do this with the "Copy Database Wizard" which gives me the error "The source and destination servers cannot be the same".  What would be the simplest way to perform the desired task?

  • November 1, 2004 at 9:23 am

    #528517

    Make a backup of the existing database and restore it with a new name.  See "How to restore a database with a new name" in Books OnLine.

    Greg

    Greg

  • November 1, 2004 at 11:58 pm

    #528561

    Use Database repl object in DTS.

  • November 2, 2004 at 11:19 pm

    #528717

    You can also use export/import wizard to make a copy of the db.

    Shakes


    Sekhar Ganpathy

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

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