Restoring SQL Server 2005 backup to SQL server 2000

I have a sql 2005 backup that I am trying to restore in sql 2000. I get the following error..

Error:3169 The backed up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. Restore filelist is terminating abnormally.

Is there a workaround for this?

Vyanki

No, there is no workaround. SQL Server 2005 does not support downgrades or restores to SQL Server 2000.

|||

thanks.

what way can be come true the case.

|||There is no "Restore" functionality, but there is a workaround to copy 2005 databases to 2000:

Right-click on DB -> tasks -> generate scripts
select DB and click "script all objects...", hit next
select any options you want, specifically changing "script for server version" to SQL Server 2000
next through and run the script

Now just export data from the 2005 database to the newly-created 2000 database.
Right-click on DB -> tasks -> export...
set source and hit next
set destination and hit next
select "copy data from one or more tables", hit next
select all, check "optimize for many tables" and "run in a transaction"
you may have to edit each table mapping and check "enable identity insert"
next through to finish

|||

Jonathan Fife wrote:

There is no "Restore" functionality, but there is a workaround to copy 2005 databases to 2000:

Right-click on DB -> tasks -> generate scripts
select DB and click "script all objects...", hit next
select any options you want, specifically changing "script for server version" to SQL Server 2000
next through and run the script

Now just export data from the 2005 database to the newly-created 2000 database.
Right-click on DB -> tasks -> export...
set source and hit next
set destination and hit next
select "copy data from one or more tables", hit next
select all, check "optimize for many tables" and "run in a transaction"
you may have to edit each table mapping and check "enable identity insert"
next through to finish

... Then what do we do once we have the DB on the SQL 2000 server but still cant import or attach it? I've received a 2005 database from my web designer and need to import it into my 2000 server.

Thanks!

Chris

|||Unfortunately, you cannot restore a SQL Server 2005 backup to SQL Server 2000. In your situation, I would install a named instance of SQL Server 2005 (alongside your default 2000 instance). Then you could restore the 2005 backup there and use it directly, or you could use SSIS to copy the data to SQL Server 2000.sql