I have a database on a SQL 2005 server that was migrated from SQL Server 2000. I migrated by backing up and then restoring the database to the SQL 2005 server.

What we'd like to do is use the old server for testing and I am trying to restore/copy the database to the old server.

I have tried restoring a backup but this terminates stating there is more than 64 headers.

I am trying to use SSIS but am being told that the source connection must have a version equal to or less than the destination.

How can I restore/copy the database from SQL 2005 to 2000? Would be grateful for any pointers.

I remmeber creating linked servers in SQL server 2005 pointing to SQL Server 2000. So I belive that it is possible to create a conenction in SSIS too. But you can't use Copy database here. You may have to copy tables one by one.
Moving the users/permissions may be tricky one. You may not be able to do that at all.
Moving the tables is quite possible if you dont have any new columns like vachar(MAX) or XML.

G.R.Preethiviraj Kulasingham

You can set a database's compatibility level:

On the database properties dialog in SQL Server Management Studio, under "Options", change "Compatibility Level" to "SQL Server 2000 (80)". You might then be able to back it up (or detach it) and restore (attach) to the SQL2000 instance.

-Peter
peterlanoie.blog