Changes to the NetBackup SQL Server Agent allow a multi-striped image to be restored with a single stripe

Problem

Changes to the NetBackup SQL Server Agent allow a multi-striped image to be restored with a single stripe.

Solution

As indicated in the related article (refer to the Related Documents below), in previous versions of NetBackup, it was not possible to restore a multiplexed backup when the device count was lower than the stream count.  

Enhancements to the NetBackup SQL database agent now allow for the restore to proceed successfully when there are fewer devices than streams, without having to first de-multiplex the image.  To perform this, save the SQL restore script as a .bch file and make the following modifications:

OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE"Northwind"
# The following image is type: Full
NBIMAGE"SQLSERVER.MSSQL7.SQLSERVER\TEST.db.Northwind.~.7.001of001.20060926102152..C"
SQLHOST"SQLSERVER"
SQLINSTANCE "TEST"
NBSERVER "NBMASTER"
STRIPES X (Wherex is the number of stripes specified during backup)
MAXTRANSFERSIZE0
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
ENDOPERTRUE

Change the STRIPES line to reflect 1:

OPERATIONRESTORE
OBJECTTYPE DATABASE
DATABASE "Northwind"
# The following image is type: Full
NBIMAGE"SQLSERVER.MSSQL7.SQLSERVER\TEST.db.Northwind.~.7.001of001.20060926102152..C"
SQLHOST"HVMC-1"
SQLINSTANCE "TEST"
NBSERVER "NBMASTER"
STRIPES 1
MAXTRANSFERSIZE 0
BLOCKSIZE 7
RESTOREOPTIONREPLACE
RECOVEREDSTATE RECOVERED
ENDOPER TRUE


Multi-striped backups can be restored using a single stream in all supported versions of NetBackup.