Back Database of SQL 2005 to SQL 2000

• satyam kumar

  Grasshopper

  Points: 12

  More actions

  March 28, 2006 at 1:13 am

  #112304

  Hi,

  We have two system one is with sql 2005 and another sql 2000. now i have import the database from sql 2005 to sql 2000.

  Pl help me to restore the sql 2005 database backup to sql 2000

   

  Thanks

  ---

  Kindest Regards,

  satyam kumar

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 28, 2006 at 1:12 pm

  #629283

  You can't restore a 2005 backup to a 2000 instance.  You might try using DTS.

  Greg

  Greg

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  March 28, 2006 at 2:44 pm

  #629302

  or SQL Server Integration Services (what DTS became in SQL Server 2005). There is an import/export wizard you may find helpful in both cases.

  K. Brian Kelley
  @kbriankelley