Any reply?????????

As i said all 3 databases are indentical. One out of 3 has more transaction as its live database. Another two used by hardly one or two users. so apart...

Host name will not work as it will give me a name of machine where application is installed.

well changing code is another problem as it is handle by third...

This perticular job is created in SQL Server And what i am doing is dropping database and restoring it. but i am using backup taken by Redgate SQL Backup.

Yes I am using Redgate SQL Backup tool to backup. Do you think that might causing job to fail? but i cant understand the reason why its generating error saying...

Hi Guys,

The database is on SQL server 2000

I can run it manually. Its not a case that this package fails everyday but its fails often