Ms sql 2005 backup fails, interrupted by 60%
Created: 09 Jan 2013 | Updated: 10 Jan 2013 | 4 comments
This issue has been solved. See solution.
Hello, please help!
- There is a server Netbackup 6.5 on SLES 11 is connected to the tape drive
- There is a MS SQL Server 2005 Ent 64x in which multiple databases
- Backing up the database size of 300 GB run at night, but for some reason today it was slow and interrupted by 60%
Here is a piece of log from the client C:\Program Files\Veritas\NetBackup\logs\dbclient
07:38:59.425 [3040.3704] <4> CODBCaccess::LogODBCerr: INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]60 percent processed.>.08:33:38.454 [3040.6580] <16> writeToServer: ERR - send() to server on socket failed:08:33:38.454 [3040.6580] <16> dbc_put: ERR - failed sending data to server08:33:38.454 [3040.6580] <4> closeApi: INF - EXIT STATUS 6: the backup failed to back up the requested files08:33:38.564 [3040.6580] <16> VxBSASendData: ERR - Could not do a bsa_put().
While a good log looks like this:
06:11:41.874 [4100.5960] <4> CODBCaccess::LogODBCerr: INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]90 percent processed.>.06:17:57.434 [4100.4248] <4> finishTarImage: INF - FractionalObjectBytes: 55771623
Can you tell where you can try to find the cause of the failure?