restoring a 2005 database on a 2000 server?

• ben potts

  Old Hand

  Points: 384

  More actions

  October 17, 2005 at 4:41 am

  #165661

  As part of my risk assessment for my final year project at uni I need to know whether its possible to load a database created in sql server 2005 into sql server 2000?

  just a simple database. 10 tables, 2 scheduled jobs, 15 or so simple queries.

  any help is appreciated,

  ben

• October 20, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Glynne Smith

  SSC Eights!

  Points: 804

  More actions

  October 20, 2005 at 9:32 am

  #598767

  I just tried and was not able to do it.

  restore headeronly from disk='d:\stage\GLYNNE_backup_200510131516.bak'

  gave me the following error;

  Server: Msg 3205, Level 16, State 2, Line 1

  Too many backup devices specified for backup or restore; only 64 are allowed.

  Server: Msg 3013, Level 16, State 1, Line 1

  RESTORE HEADERONLY is terminating abnormally.

   

  From the SQL 2005 online help;

  Backups created with Microsoft SQL Server 2005 cannot be restored to an earlier version of SQL Server.