Sql Server 2005 Backup to be restored in SQL Server 2000

• Mohammed Wajeed-417164

  Grasshopper

  Points: 11

  More actions

  March 10, 2007 at 12:22 am

  #119177

  Hi,

  I want to take a backup of SQLServer 2005 Database to be compatable with SQLServer 2000.

  I tried restoring SQL2005  backup in SQLServer 2000 but it gives me version conflict.

  regards

  wajeed

   

   

   

• einman33

  SSCrazy

  Points: 2813

  More actions

  March 10, 2007 at 1:03 am

  #694221

  I had zero luck in acomplising this as a restore. I have come to the assumption it is not possible. Any bcp/ssis task to export then import could meet your needs, albeit in a very slow manner.

• James Moore (Red Gate)

  SSCrazy

  Points: 2644

  More actions

  March 10, 2007 at 2:21 am

  #694222

  You cant restore 2005 backups to SQL Server 2000, you would have to use BCP or some similar mechanism to move the data.

  - James

  --
  James Moore
  Red Gate Software Ltd