Configure one server to another server

• kumar99ms

  SSCommitted

  Points: 1584

  More actions

  September 18, 2008 at 2:46 am

  #72877

  Hi Every body

  How can i configure & Copy form one server data to another server in ms sql server 2000

  Could any please help to me

  really appricate to you.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 20, 2008 at 12:23 pm

  #874625

  There are several ways to do this. Some of them are as below.

  Backup and Restore

  Use DTS

  Copy Database Wizard

  Log shipping.

  Please refer BOL for more information.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736140

  More actions

  September 20, 2008 at 2:40 pm

  #874631

  If you give more information on why you are doing this and what your requirements are, we can give you more guidance.