Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- VOX
- Data Protection
- NetBackup
- Skipped databases while doing a MS SQL database ba...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2010 08:59 AM
Hello,
Here's the problem:
While doing a MS SQL database backup, the temporary batch file generates a list of all databases (let’s say they are 20), after that the backup starts, the first 2 databases each generates a job and finishes with success. However the rest of the databases (18 more) do not generate a job each but instead the master job completes with status 0 - "the requested operation was successfully completed (0)".
I've enabled and checked all kind of logs I could think of and wasn't able to find any reason for this to happen.
Here are some environment details:
- NBU master (and media) server is HPUX OS, version 6.5.4
- Client server is win 2003, NBU client version 6.5.4
Any ideas what could be the reason and where to look at?
Thank you forward.
Solved! Go to Solution.
Labels:
1 ACCEPTED SOLUTION
Accepted Solutions
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2010 07:50 AM
This is a "feature" lol, our SQL DBA found it, do we get a cookie?
Here is the alert they sent out:
This is to inform you that Symantec Corporation has just issued a Software Alert. This is a critical technical issue for:
Check your stripes and other memory settings, since that can also impact this.
Here is the alert they sent out:
This is to inform you that Symantec Corporation has just issued a Software Alert. This is a critical technical issue for:
-NetBackup Enterprise Server 6.5 through 6.5.5 on Supported Windows platforms
For complete details and our recommendations, please visit the following reference document:
When a large number of databases are enumerated in an SQL batch file, or when the DATABASE $ALL wildcard is used to enumerate a large number of databases, some databases are skipped and not all databases are backed up. No failure is reported in the Activity Monitor.
http://entsupport.symantec.com/docs/330033
This Software Alert was delivered because responsiveness to customers and product quality are consistent Symantec Corporation hallmarks. Any issue that could potentially affect the integrity of data in your environment, no matter how rare, is viewed as extremely important.
Thank you for choosing Symantec.
Sincerely,
Symantec
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2010 09:16 AM
Will you please post the .bch file that you are using?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2010 01:49 PM
You will need to compare .bch file with dbclient log file on client - each database specified in batch file will be listed in log file with result for each of them.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2010 04:36 AM
Hello,
I've reistalled the client software (just to be sure). The next attempt managed to backup 6 of 25 databases.
Also, missed to mention that its a SQL cluster server.
Here's some comprehensive data (server names were replaced with standard one):
The template I'm using:
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\sqlscript_db_1.bch :
----------
OPERATION BACKUP
DATABASE $ALL
SQLHOST "CLIENTSQL01"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01"
NUMBUFS 2
ENDOPER TRUE
----------
Here's the generated template:
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\temp\0-2556-7204sqlscript_db_1.bch :
----------
GROUPSIZE 25
OPERATION BACKUP
DATABASE "AcsData"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "AcsLog"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "DocumentArchive"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "HPRNR"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "master"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "model"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "msdb"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "OperationsManager"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_0000"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2004"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2005"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2006"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007_RESTORE"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2008"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2009"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2010"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "ProvDB1"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "PTMS_SQL"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SFCR_TEST"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SLTS-INTEL-INV"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SUSDB"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SymantecEndpoint"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "UPDATE_PTMS"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "VDI_SWA"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
----------
C:\Program Files\Veritas\NetBackup\logs\user_ops\MsSql\Logs\log :
GROUPSIZE 25
OPERATION BACKUP
DATABASE "AcsData"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "AcsLog"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "DocumentArchive"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "HPRNR"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "master"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "model"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "msdb"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "OperationsManager"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_0000"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2004"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2005"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2006"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007_RESTORE"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2008"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2009"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2010"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "ProvDB1"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "PTMS_SQL"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SFCR_TEST"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SLTS-INTEL-INV"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SUSDB"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SymantecEndpoint"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "UPDATE_PTMS"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "VDI_SWA"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 1
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.AcsData.~.7.001of001.20100128071128..C
INF - backup database "AcsData" to VIRTUAL_DEVICE='VNBU0-2556-7128-1264680689' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
Backup started Thu Jan 28 07:11:30 2010
07:11:33 Initiating backup
07:11:38 INF - Data buffer size = 65536
07:11:39 INF - Beginning backup on server NBUMASTER01 of client CLIENTSQL01V1
07:11:40 INF - Data socket = NBUMASTER01.company.com.IPC:63794;9057dc03e8004dc50ce944cd1930129c;4;1800
07:11:40 INF - Name socket = NBUMASTER01.company.com.IPC:63795;15979c0dd33c9bbbcffcf85b382ae7aa;4;1800
07:11:40 INF - Job id = 729352
07:11:40 INF - Backup id = CLIENTSQL01V1_1264680696
07:11:40 INF - Backup time = 1264680696
07:11:40 INF - Policy name = SW_SQL_DB_CLIENTSQL01V1
07:11:40 INF - Snapshot = 0
07:11:40 INF - Frozen image = 0
07:11:40 INF - Backup copy = 0
07:11:40 INF - Master server = NBUMASTER01
07:11:40 INF - Media server = NBUMASTER01
07:11:41 INF - Multiplexing = 24
07:11:41 INF - New data socket = NBUMASTER01.company.com.IPC:63793;6b79e065b1d7248036bce708c1038c81;4;1800
07:11:41 INF - Use shared memory = 0
07:11:41 INF - Compression = 0
07:11:41 INF - Encrypt = 0
07:11:41 INF - Keep logs = 4
07:11:41 INF - Client read timeout = 9000
07:11:41 INF - Media mount timeout = 0
INF - Thread has been closed for stripe #0
07:11:55 INF - Server status = 0
07:11:56 INF - Backup by usfsgnetbu on client CLIENTSQL01V1 using policy SW_SQL_DB_CLIENTSQL01V1, sched Default-Application-Backup:the requested operation was successfully completed
INF - OPERATION #1 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(1) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 2
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.AcsLog.~.7.001of001.20100128071204..C
INF - backup database "AcsLog" to VIRTUAL_DEVICE='VNBU0-2556-6772-1264680725' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #2 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(0) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 3
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.DocumentArchive.~.7.001of001.20100128071240..C
INF - backup database "DocumentArchive" to VIRTUAL_DEVICE='VNBU0-2556-8024-1264680761' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #3 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 27(1) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 4
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.HPRNR.~.7.001of001.20100128071310..C
INF - backup database "HPRNR" to VIRTUAL_DEVICE='VNBU0-2556-2512-1264680791' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #4 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 34(7) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 5
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.master.~.7.001of001.20100128071347..C
INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-2556-7184-1264680828' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #5 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(0) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 6
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.model.~.7.001of001.20100128071422..C
INF - backup database "model" to VIRTUAL_DEVICE='VNBU0-2556-6852-1264680864' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #6 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(1) seconds
INF - Results of executing <C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch>:
<6> operations succeeded. <0> operations failed.
---------------
Any ideas?
I've reistalled the client software (just to be sure). The next attempt managed to backup 6 of 25 databases.
Also, missed to mention that its a SQL cluster server.
Here's some comprehensive data (server names were replaced with standard one):
The template I'm using:
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\sqlscript_db_1.bch :
----------
OPERATION BACKUP
DATABASE $ALL
SQLHOST "CLIENTSQL01"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01"
NUMBUFS 2
ENDOPER TRUE
----------
Here's the generated template:
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\temp\0-2556-7204sqlscript_db_1.bch :
----------
GROUPSIZE 25
OPERATION BACKUP
DATABASE "AcsData"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "AcsLog"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "DocumentArchive"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "HPRNR"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "master"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "model"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "msdb"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "OperationsManager"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_0000"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2004"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2005"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2006"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007_RESTORE"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2008"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2009"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2010"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "ProvDB1"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "PTMS_SQL"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SFCR_TEST"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SLTS-INTEL-INV"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SUSDB"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SymantecEndpoint"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "UPDATE_PTMS"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "VDI_SWA"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
----------
C:\Program Files\Veritas\NetBackup\logs\user_ops\MsSql\Logs\log :
GROUPSIZE 25
OPERATION BACKUP
DATABASE "AcsData"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "AcsLog"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "DocumentArchive"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "HPRNR"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "master"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "model"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "msdb"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "OperationsManager"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_0000"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2004"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2005"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2006"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2007_RESTORE"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2008"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2009"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "Prop_2010"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "ProvDB1"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "PTMS_SQL"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SFCR_TEST"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SLTS-INTEL-INV"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SUSDB"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "SymantecEndpoint"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "UPDATE_PTMS"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "VDI_SWA"
SQLHOST "CLIENTSQL01V1"
NBSERVER "NBUMASTER01"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
BROWSECLIENT "CLIENTSQL01V1"
NUMBUFS 2
ENDOPER TRUE
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 1
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.AcsData.~.7.001of001.20100128071128..C
INF - backup database "AcsData" to VIRTUAL_DEVICE='VNBU0-2556-7128-1264680689' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
Backup started Thu Jan 28 07:11:30 2010
07:11:33 Initiating backup
07:11:38 INF - Data buffer size = 65536
07:11:39 INF - Beginning backup on server NBUMASTER01 of client CLIENTSQL01V1
07:11:40 INF - Data socket = NBUMASTER01.company.com.IPC:63794;9057dc03e8004dc50ce944cd1930129c;4;1800
07:11:40 INF - Name socket = NBUMASTER01.company.com.IPC:63795;15979c0dd33c9bbbcffcf85b382ae7aa;4;1800
07:11:40 INF - Job id = 729352
07:11:40 INF - Backup id = CLIENTSQL01V1_1264680696
07:11:40 INF - Backup time = 1264680696
07:11:40 INF - Policy name = SW_SQL_DB_CLIENTSQL01V1
07:11:40 INF - Snapshot = 0
07:11:40 INF - Frozen image = 0
07:11:40 INF - Backup copy = 0
07:11:40 INF - Master server = NBUMASTER01
07:11:40 INF - Media server = NBUMASTER01
07:11:41 INF - Multiplexing = 24
07:11:41 INF - New data socket = NBUMASTER01.company.com.IPC:63793;6b79e065b1d7248036bce708c1038c81;4;1800
07:11:41 INF - Use shared memory = 0
07:11:41 INF - Compression = 0
07:11:41 INF - Encrypt = 0
07:11:41 INF - Keep logs = 4
07:11:41 INF - Client read timeout = 9000
07:11:41 INF - Media mount timeout = 0
INF - Thread has been closed for stripe #0
07:11:55 INF - Server status = 0
07:11:56 INF - Backup by usfsgnetbu on client CLIENTSQL01V1 using policy SW_SQL_DB_CLIENTSQL01V1, sched Default-Application-Backup:the requested operation was successfully completed
INF - OPERATION #1 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(1) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 2
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.AcsLog.~.7.001of001.20100128071204..C
INF - backup database "AcsLog" to VIRTUAL_DEVICE='VNBU0-2556-6772-1264680725' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #2 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(0) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 3
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.DocumentArchive.~.7.001of001.20100128071240..C
INF - backup database "DocumentArchive" to VIRTUAL_DEVICE='VNBU0-2556-8024-1264680761' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #3 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 27(1) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 4
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.HPRNR.~.7.001of001.20100128071310..C
INF - backup database "HPRNR" to VIRTUAL_DEVICE='VNBU0-2556-2512-1264680791' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #4 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 34(7) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 5
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.master.~.7.001of001.20100128071347..C
INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-2556-7184-1264680828' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #5 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(0) seconds
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch, Op# = 6
INF - Using backup image CLIENTNODE01.MSSQL7.CLIENTSQL01V1.db.model.~.7.001of001.20100128071422..C
INF - backup database "model" to VIRTUAL_DEVICE='VNBU0-2556-6852-1264680864' 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 <CLIENTSQL01V1>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #6 of batch C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 33(1) seconds
INF - Results of executing <C:\Program Files\veritas\netbackup\dbext\mssql\sqlscript_db_1.bch>:
<6> operations succeeded. <0> operations failed.
---------------
Any ideas?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2010 07:50 AM
This is a "feature" lol, our SQL DBA found it, do we get a cookie?
Here is the alert they sent out:
This is to inform you that Symantec Corporation has just issued a Software Alert. This is a critical technical issue for:
Check your stripes and other memory settings, since that can also impact this.
Here is the alert they sent out:
This is to inform you that Symantec Corporation has just issued a Software Alert. This is a critical technical issue for:
-NetBackup Enterprise Server 6.5 through 6.5.5 on Supported Windows platforms
For complete details and our recommendations, please visit the following reference document:
When a large number of databases are enumerated in an SQL batch file, or when the DATABASE $ALL wildcard is used to enumerate a large number of databases, some databases are skipped and not all databases are backed up. No failure is reported in the Activity Monitor.
http://entsupport.symantec.com/docs/330033
This Software Alert was delivered because responsiveness to customers and product quality are consistent Symantec Corporation hallmarks. Any issue that could potentially affect the integrity of data in your environment, no matter how rare, is viewed as extremely important.
Thank you for choosing Symantec.
Sincerely,
Symantec
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2010 07:55 AM
Another workaround for this issue is to break up large backup jobs into smaller jobs handling less databases.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2010 08:06 AM
Excellent find. Milo please mark David's post as the solution so that others will be able to click right to it.
Thanks!
In that document that David provided is this link:
NB_6.5.5_ET1887452_1_330184.zip is a NetBackup 6.5.5 EEB (Emergency Engineering Binary) for Windows clients
http://support.veritas.com/docs/330184
Details:
Download Now - 1084 K
File Name: NB_6.5.5_ET1887452_1_330184.zip
File Type: Patch
Click Below to Browse the FTP files by Product:
ftp.support.veritas.com/pub/support/products
.
Thanks!
In that document that David provided is this link:
NB_6.5.5_ET1887452_1_330184.zip is a NetBackup 6.5.5 EEB (Emergency Engineering Binary) for Windows clients
http://support.veritas.com/docs/330184
Details:
Symantec Bug ID: 1887452
Version: NetBackup_6.5.5
Installation Location: Client
Fixes Included:
(ET1887452) When a large number of databases are enumerated in an SQL batch file, or when the "DATABASE $ALL" wildcard is used to enumerate a large number of databases, some databases are skipped and not all databases are backed up. No failure is reported in the Activity Monitor.
http://support.veritas.com/docs/330033
Note: This package is intended to address a specific condition or issue within an environment which meets the criteria documented above. DO NOT install this package if your environment is not experiencing the specific issue or does not match the criteria in which the issue could occur.
Installation Instructions:
Please follow the EEB Installer instructions available on http://support.veritas.com/docs/313221
Package Contents:
Please choose the appropriate platform after download:
eebinstaller.1887452.1.AMD64.exe
eebinstaller.1887452.1.IA64.exe
eebinstaller.1887452.1.x86.exe
Deliverables:
--
NetBackup\bin\dbbackmain.dll
File checksum:
--
2536117400 864768 AMD64/dbbackmain.dll
3527929401 1562112 IA64/dbbackmain.dll
826089939 602112 x86/dbbackmain.dll
Recommended service state:
NetBackup SQL backups should not be running on the client when applying this EEB.
Version: NetBackup_6.5.5
Installation Location: Client
Fixes Included:
(ET1887452) When a large number of databases are enumerated in an SQL batch file, or when the "DATABASE $ALL" wildcard is used to enumerate a large number of databases, some databases are skipped and not all databases are backed up. No failure is reported in the Activity Monitor.
http://support.veritas.com/docs/330033
Note: This package is intended to address a specific condition or issue within an environment which meets the criteria documented above. DO NOT install this package if your environment is not experiencing the specific issue or does not match the criteria in which the issue could occur.
Installation Instructions:
Please follow the EEB Installer instructions available on http://support.veritas.com/docs/313221
Package Contents:
Please choose the appropriate platform after download:
eebinstaller.1887452.1.AMD64.exe
eebinstaller.1887452.1.IA64.exe
eebinstaller.1887452.1.x86.exe
Deliverables:
--
NetBackup\bin\dbbackmain.dll
File checksum:
--
2536117400 864768 AMD64/dbbackmain.dll
3527929401 1562112 IA64/dbbackmain.dll
826089939 602112 x86/dbbackmain.dll
Recommended service state:
NetBackup SQL backups should not be running on the client when applying this EEB.
Download Now - 1084 K
File Name: NB_6.5.5_ET1887452_1_330184.zip
File Type: Patch
Click Below to Browse the FTP files by Product:
ftp.support.veritas.com/pub/support/products
.
Related Content
- Netbackup Database Extension SQL GUI in NetBackup
- How Do I Backup and Restore My AI Database? A Look Into ChromaDB and AI/LLM Databases in NetBackup
- MS SQL VADP Application State Capture (ASC) Backups are Fully Recoverable in NetBackup 10.4 in NetBackup
- the specified policy does not exist in the configuration database in NetBackup
- Sooooo…How Are You Getting Your AI Back After a Disaster? in NetBackup
