I do not think you can restore a SQL Server 2005 backup to SQL Server 2000 (hopefully someone will correct me if it is indeed possible). Consider installing a named instance of SQL Server 2005 (alongside your default 2000 instance) and then restore the 2005 backup there and use it directly or use SSIS to copy the data to SQL Server 2000.



>How to restore a Sql Server 2005 database backup to Sql Server 2000
>
>Hi All
>
>This is a very urgent requirement of my client having 500 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working fine when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out.
>
>
>
>Thanks
>
>Raoshan