We have a Production DB Server (SQL Server 2000) and Reporting DB Server (SQL Server 2005)
Earlier both servers were having SQL 2000. But now they have upgraded Reporting DB Server to SQL 2005.
Backup Process – We have a process which syncs 5 databases between Production and Reporting. Complete restore is taken on a weekly basis (Sunday) and transaction logs are taken on a daily basis.

After upgradation of Reporting server to SQL Server 2005, backup process is not running as expected.
We were able to restore the complete backup successfully which happens weekly. But having some issues while restoring transaction logs.

While trying to restore the database and transaction logs , we have 3 status modes:
Recovery : We can’t use it, as it does not allow to restore transaction logs. If transaction logs are not there, we can use it very well for complete backup.
NoRecovery : It can be used to restore but again database is no useable. It will be in recovery mode.
StandBy : In the old reporting server(SQL 2000), they were using StandBy mode.
It is read-only mode. But we are not able to use it as it says a message “This backup cannot be restored using WITH STANDBY because a database upgrade
is needed. Reissue the RESTORE without WITH STANDBY.”
As backup is from SQL 2000, it can’t be restored on SQL 2005.

We have restored the complete backup which was done using “recovery” mode. If complete backup is done in “recovery” mode, it is not restoring transaction logs.

Could you please help me out in resolving this issue