Clone Database

• Amar Sevak

  Grasshopper

  Points: 11

  More actions

  January 21, 2004 at 12:06 am

  #82138

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

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  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.

   

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  January 21, 2004 at 8:11 am

  #490988

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

• webnando

  SSC Enthusiast

  Points: 153

  More actions

  January 22, 2004 at 5:59 am

  #491098

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

  

• StephenMarais

  SSC-Addicted

  Points: 442

  More actions

  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