X hits on this document

625 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 views625
Page views625
Page last viewedWed Jan 18 20:52:43 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments