X hits on this document

401 views

0 shares

0 downloads

0 comments

118 / 200

118

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.

Backup names

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.

Instance

Object type2

Database

name1

name3

Version Indicator

Host where SQL Server resides

SQL Server identifier

cole.MSSQL7.cole\INSTANCE2.fg.abc.PRIMARY.7.001of001.20060902170824.C:

File or filegroup name

Blocksize4

Stripes5

Timestamp6

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

blocksize

.

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.

Document info
Document views401
Page views401
Page last viewedSat Dec 03 05:17:26 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments