Post reply

Clone Database

  • January 21, 2004 at 12:06 am

    #82138

    In Sql Server 2000 which is the best method to clone a Database

  • January 21, 2004 at 6:06 am

    #490954

    If you need to have the clone db continuosly with the last changes, you should choose between log shipping and replication.

      Wich one is better will depend of how much latency you can support.

     

     

  • January 21, 2004 at 8:11 am

    #490988

    For a one time shot I use backup restore. Or for something like refreshing QA.

  • January 22, 2004 at 5:59 am

    #491098

    To do this you can use a 'Copy Databases Wizard' on Enterprise Manager!

  • January 22, 2004 at 8:53 am

    #491141

    I found the best approach is to detach the original database files and copy them to the new location and then reattaching both sets of files again.

    Stephen Marais
    Integration Architect
    Digiata Technologies
    www.digiata.com

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

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