Urgent!! SQL Restore Problems

Hi,

Can someone please help urgently. I have a number of databases that I have set maintenance plans for. I am trying to restore these databases by using a stored proceedure. It was successful on my testing server, but when i try it on the production servers i have an error:

Server: Msg 913, Level 16, State 8, Line 1
Could not find database ID 65535. Database may not be activated yet or may be in transition.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.



If I do the following on the production machine it works:



RESTORE FILELISTONLY FROM DISK =
'E:SQL_TEST_RestoreCPROD_db_200608220410.BAK'

restore database CPROD
FROM DISK ='E:SQL_TEST_RestoreCPROD_db_200608220410.BAK'
with recovery,
Move 'CPROD_Data' to 'E:SQL_DATAMSSQLDataCPROD_Data.MDF',
Move 'CPROD_Log' to 'E:SQL_DATAMSSQLLogCPROD_Log.LDF'



But this is not the point as the maintenance plan is set to have 15minute backups and if this was to be done manually It would take forever to restore all the databases.

I did find one differnece with the test and production servers:

The collation for my test box is LATIN1_GENERAL_CP1_CI_CS

and the production machine is LATIN1_GENERAL_CP850_CS_AS

Dont know if that helps. I can post the script if necessary

Thanks

Michael