Restore job fails in SQL Server
Posted on 2009-05-16
I have a job LSRestore_IHS_MAIN-SQL-02-P51 that fails.
When I go in the steps I just see
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqllogship.exe" -Restore C95BF037-BDE6-4B38-9985-2A0E3E2E6595 -server IHS-MAIN-IMG-01. Nothing else.
Now when I see history I see------
The job failed. The job was invoked by schedule 136 (DefaultRestoreJobSchedule). The last step to run was step 1. (Log Shipping Restore Log job step).
More in detail--------------
Executed as user HIS\Sqlrptuser. The step failed.
so what is the problem. let me tell you that P51 database does not exist. if you see the first line it says that LSRestore_IHS_MAIN-SQL-02-P51