Using NetBackup for SQL Server Using bplist to retrieve SQL Server backups
juneberry.MSSQL7.JUNEBERRY\NEWINSTANCE.inc.Howard's Barbeque.~.7.001of001.20060903108552..C:\ juneberry.MSSQL7.COLE.db.pubs.~.7.001of001.20060907100101..C:\ juneberry.MSSQL7.COLE.db.pubs.~.7.001of001.20060908200234..C:\
Note: The colon and backslash, which terminate each line, are not part of the backup name.
The backup name is a string consisting of the following components separated by a delimiter specified by the character preceding the “C” at the end of the backup image name.
Host where SQL Server resides
SQL Server identifier
File or filegroup name
1. Named instances are formatted as host\instance-name. The default instance is simply the name of the host machine.
2. The object types are db, for database; inc, for database differential; trx, for transaction log; fg, for filegroup; fdg, for filegroup differential; fil, for file.
3. The name of the file or filegroup if the object type is a file or filegroup; otherwise the symbol ~ is used.
4. The blocksize is specified as 256 kilobytes bytes * 2
5. Stripes are specified as <stripe number>of<total stripes>. non-striped backups are always 001of001. For striped backups, <total stripes> is the total number of stripes for the backup. <stripe number> is the count number of the backup for that backup, starting with 001.
6. The format of the timestamp is YYYYMMDDHHMMSS.
7. The character immediately preceding the version indicator is the delimiter, which by default is a period. However, if a period is used in any of the fields, the delimiter may be another character. “C” is for NetBackup 3.4.1 and higher.