MS SQL backups for a single Database happening partially
Hi All,
Master Server: Sun Solarisn 5.10
NBu version: 7.5.0.6
MS Sql Server:
Microsoft windows server 2003
SQL server version 2008
Nbu version : 7.5.0.6, Client server
Media Server:
Solaris10
NBu version: 7.5.0.6
My SQL backup for a perticular database is failing continuously with status 1. While the other databases on the server are getiing successfuly backed up everyday.
The logs are mentioned below which state that the backup has happened partially :
INF - BACKUP STARTED USING
Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86)
Sep 22 2011 00:28:06
Copyright (c) 1988-2008 Microsoft Corporation
Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2) (VM)
Batch = diff_2008.bch, Op# = 1
INF - Using backup image mlxibgmbiap3.MSSQL7.MLXIBGMBIAP3\SQL2008STD.inc.lts.~.7.001of001.20141226180614..C
INF - backup database "lts" to VIRTUAL_DEVICE='VNBU0-23664-12980-1419597378' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, differential
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SQL2008STD>. Connection timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003.
CONTINUATION: - The api was waiting and the timeout interval had elapsed.
ERR - Error in VDS->Close: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch diff_2008.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 321(0) seconds
The script is as follows:
OPERATION BACKUP
DATABASE "lts"
SQLHOST "mlxibgmbiap3"
SQLINSTANCE "SQL2008STD"
NBSERVER "HYDT5440-NBMS"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
DUMPOPTION INCREMENTAL
NUMBUFS 2
ENDOPER TRUE
If I try to start a backup for the individual database after making sure that no " dbbackup.exe or dbbackex.exe" process are running I get the below mentioned errors:
OPERATION BACKUP
DATABASE "lts"
SQLHOST "mlxibgmbiap3"
SQLINSTANCE "SQL2008STD"
NBSERVER "HYDT5440-NBMS"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY MLXIBGMBIAP3-SQL2008STD-DIFF
NUMBUFS 2
ENDOPER TRUE
INF - BACKUP STARTED USING
Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86)
Sep 22 2011 00:28:06
Copyright (c) 1988-2008 Microsoft Corporation
Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2) (VM)
Batch = C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__11_12_18_261_00.bch, Op# = 1
INF - Using backup image mlxibgmbiap3.MSSQL7.MLXIBGMBIAP3\SQL2008STD.db.lts.~.7.001of001.20141226111220..C
INF - backup database "lts" to VIRTUAL_DEVICE='VNBU0-24244-23880-1419572542' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SQL2008STD>. Connection timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003.
CONTINUATION: - The api was waiting and the timeout interval had elapsed.
ERR - Error in VDS->Close: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__11_12_18_261_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 311(0) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__11_12_18_261_00.bch>:
<0> operations succeeded. <1> operations failed.
INF - The following object(s) were not backed up successfully.
INF - lts
Kindly sugest how to know the reason for the partial backup and way to resolve it.
Thanks.
Have you checked MS-SQL errorlog and VDI logs as well?
All I can see in the dbclient log is a 5 minute timeout.
Try to increase VDI and NBU timeouts:
In backup script, add:VDITIMEOUTSECONDS 900
On Media server, increase Client Connect and Client Read Timeout to 900.
We have seen that large databases may even need timeouts of 1800.
