restore a SQL 2005 database on SQL 2000

Hello,

If I have a SQL 2005 database set to SQL 2000 Compatiblity can I create a backup on SQL 2005 that can be restore on SQL 2000.

Michael

No, SQL Server 2005 backups are not valid for a restore on a SQL Server 2000. If you want to transfer the data to the SQL Server 2000 use the data transfer wizard.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de