#SQL Backup Label number

Article Number: 503823Article Version: 3 Article Type: How To





Avamar Client



This article explain how label number works for Avamar on SQL Backup.

Instructions 1 – Database backups are created by backing up each individual database as a partial backup, partial at this point means, a piece, a backup of each database its part of an entire backup. A partial backup is just that – it’s a piece of a backup that doesn’t stand on its own.

As we can see below, each labelnum represent a partial backup.

<file internal=”false” labelnum=”1372″ fullname=”SQLSQLDB/db2/i-2.stream0″ acnt=”/clients/sql.moja.com” saveas=”i-1.stream0″ />

<file internal=”false” labelnum=”1371″ fullname=”SQLSQLDB/db2/f-0.stream0″ acnt=”/clients/sql.moja.com” />

<file internal=”false” labelnum=”1370″ fullname=”SQLSQLDB/db4/i-2.stream0″ acnt=”/clients/sql.moja.com” saveas=”i-1.stream0″ />

<file internal=”false” labelnum=”1369″ fullname=”SQLSQLDB/db3/i-2.stream0″ acnt=”/clients/sql.moja.com” saveas=”i-1.stream0″ />

<file internal=”false” labelnum=”1368″ fullname=”SQLSQLDB/db4/f-0.stream0″ acnt=”/clients/sql.moja.com” />

<file internal=”false” labelnum=”1367″ fullname=”SQLSQLDB/db3/f-0.stream0″ acnt=”/clients/sql.moja.com” />

2- Later, then calling a “snapview” to tie those backups together into a restorable set.

(Essentially, snapview, ties partial backups together into a restorable set.).

So, the backup above will become only one number in the Avamar Administrator.

The snapview process is how Avamar ties partial backups together into a restorable set. After the backup of each database is complete, a final avtar runs that collects the root hashes of the partial backups and ties them together. This process of tying the backups together is a snapview.

Streams:

Avatar consider as partial backup each stream, for this reason, we have a one labelnum for each stream.

Based in example below, the configuration below we have 5 streams, for larger databases, we can see the 5 streams, so 5 label number because it each stream is a partial backup.

<flag type=”integer” pidnum=”3006″ value=”5″ name=”max-parallel” />

<file internal=”false” labelnum=”259344″ fullname=”sqlinstraveleef-0.stream0″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259343″ fullname=”sqlinstraveleef-0.stream2″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259342″ fullname=”sqlinstraveleef-0.stream1″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259340″ fullname=”sqlinstraveleef-0.stream3″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259341″ fullname=”sqlinstraveleef-0.stream4″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259367″ fullname=”sqlinsadminsysf-0.stream3″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259368″ fullname=”sqlinsadminsysf-0.stream2″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259369″ fullname=”sqlinsadminsysf-0.stream1″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259365″ fullname=”sqlinsadminsysf-0.stream4″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259366″ fullname=”sqlinsadminsysf-0.stream0″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259362″ fullname=”sqlinsCoref-0.stream3″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259364″ fullname=”sqlinsCoref-0.stream4″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259363″ fullname=”sqlinsCoref-0.stream1″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259360″ fullname=”sqlinsCoref-0.stream0″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259361″ fullname=”sqlinsCoref-0.stream2″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259349″ fullname=”sqlinsLCS_SQLf-0.stream4″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259347″ fullname=”sqlinsLCS_SQLf-0.stream1″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259348″ fullname=”sqlinstLCS_SQLf-0.stream0″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259346″ fullname=”sqlinsLCS_SQLf-0.stream3″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

<file internal=”false” labelnum=”259345″ fullname=”sqlinsLCS_SQLf-0.stream2″ acnt=”/SQLServers/Production/Cluster/sql.labemc.local” />

Related:

Leave a Reply