I have a database that is backed up each night at 12am. After the backup (on server 1), the backup is restored to a test server (server 2). Sometimes it fails and Iâ€™m not sure as to why. Rerunning the job in the morning when I get in it works fine. So Iâ€™m unsure as to why it is failing. Here is the error that RedGate is displaying. I was hoping for more as these seem to be very general errors:
Thread 0 Error:
File read error for 152135 bytes. Backup file is incomplete or corrupted.
SQL error 3013
SQL error 3241
I suspect the problem is coming from the network or the SANs but don't see anything in the event log or in the SQL log. Is there anywhere I can get some more specific information?