Problem - restore step is failing for one out of four dbs...
What I'm confused about is why this is only happening to one out of four databases. They were set up identically, so I would expect all four to fail or all four to succeed on such mundane things as logins.
The other thing that has me baffled is I have email set up to send status of EVERY job. I only had SUCCESS messages all weekend.
Anyone know what is going on?
Date 3/5/2007 9:20:00 AM
Log Job History (Log shipping: restore [Whaley])
Step ID 1
Job Name Log shipping: restore [Whaley]
Step Name Step 1
Sql Severity 16
Sql Message ID 50000
Operator Net sent
Retries Attempted 0
Executed as user: WHALEY03\SQLBackup. SQL Backup job failed with exitcode: 220 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.