About NetBackup for SQL Server backup names
The backup name is a string that consists of the following components. These components are separated by a delimiter that is specified by the character that precedes the "C" at the end of the backup image name. Backup images for standalone instance databases or read-scale availability groups include the host and the instance name. Backup images for advanced and basic availability groups include the cluster name, availability group node name, and availability group name.
1 - Named instances are formatted as <host>\<instance-name>. The default instance is the name of the host machine.
2 - The object types are as follows:
db | database |
inc | database differential |
trx | transaction log |
fg | filegroup |
fgd | filegroup differential |
fil | 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 block size.
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. The timestamp for availability gorup backup images reflects Coordinated Universal Time (UTC). For standard database backup images, the timestamp reflects the time zone that is configured for the NetBackup server.
7 - The delimiter, which immediately precedes the version indicator. For standard database images, this character is a period (.) by default. For availability database images, the character is a forward slash (/). However, if a period or slash is used in any of the fields, the delimiter may be another character.
8 - "C" is applied to all SQL Server backup image names, regardless of the NetBackup version.
9 - Backup images for AG databases are formatted as <WindowsServerFailoverCluster>:<nodename>/MSSQL7/<AGname>.