Forum Discussion

MiloHaze's avatar
MiloHaze
Level 3
16 years ago
Solved

Skipped databases while doing a MS SQL database backup.

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.
7.1.x and Earlier
Backup and Recovery
Configuring
HP-UX
Integration
NetBackup
Windows
  • David_McMullin's avatar
    David_McMullin
    16 years ago
    This is a "feature" lol, our SQL DBA found it, do we get a cookie?

     

    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

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    16 years ago
    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.
  • MiloHaze's avatar
    MiloHaze
    Level 3
    16 years ago
    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?
  • David_McMullin's avatar
    David_McMullin
    Level 6
    16 years ago
    This is a "feature" lol, our SQL DBA found it, do we get a cookie?

     

    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


  • Will_Restore's avatar
    Will_Restore
    Level 6
    16 years ago
    Another workaround for this issue is to break up large backup jobs into smaller jobs handling less databases.
  • Stumpr2's avatar
    Stumpr2
    Level 6
    16 years ago
    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:
    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.


     

    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


    .