Symantec/Veritas – Backup Exec – Opened Files Options

Background

As a working DBA, backing up files is an area that is close to me.

Our Corporate Backup Platform is Symantec\Veritas, let us see how it handles live database files.

 

Job

Configuration

“Use Advanced Open File Option” – Unchecked

When creating a job, we can either accept the default option of not taking any special precaution with Opened Files.

In the screenshot below, we left “Use Advanced Open File Option” unchecked.

AdvancedOpenFileOption-Disabled

Report

JobHistory-FilesIsInUse

Explanation

Our SQL database files are marked “Files is in use“.

 

“Use Advanced Open File Option” – Checked

On the other hand, when we check the “Advanced Open File Option” option, we are able to decide how we want to handle Opened Files.

The available options are:

  1. Automatic – Allow VSS to select the snapshot provider
  2. System – Use Microsoft Software Shadow Copy Provider
  3. Software – Veritas Storage Foundation for Windows
  4. Hardware – Use technology provided by hardware manufacturer

 

We took Option 2 – “System use Microsoft Software Shadow Copy Provider” for a quick drive.

 

Report

BackupDetailInformation

Explanation

 

We no longer have skipped files.

 

Configuration

Exclusion List

We are handling our SQL Server Backups through the built-in SQL Server tools. In essence, we are not quite interested in backing up the live opened SQL Server data and log files.

We will thus exclude those through the Exclusion List option.

The steps are documented are.

And, they are

  1. Use the menu options ” Edit”\”Manage Selection List”
  2. Choose the “Excludes” item

 

Manage Selection List

ManageSelectionLists

 

Exclude Properties ( Before )

Here is the empty list

ExcludeProperties-EmptyList

We click the Insert button

Include/Exclude Selection

The choices we make in the “Include/Exclude Selections”  is detailed below:

  1. Resource type :- General
  2. Path :- \\*\*
    • The first * means all computers\hosts
    • The second * means all drives on the designated hosts
  3. File
    • *.mdf
  4. Selection criteria
    • Include subdirectories

 

ExcludeProperties-mdf

Clicked OK button and repeat same steps replacing *.mdf with *.ndf and *.ldf.

 

Exclude Properties ( After )

Here is our completed list

ExcludeProperties-CompletedList

 

Summary

Again, Backup Exec satisfactory and gracefully handles in-use files.

There are at minimum two avenues for handling them.

The more granular option is to handle them at individual job configuration levels.  When handled at the job level, we are able to utilize Microsoft’s Shadow Copy Option or Veritas Storage Foundation.

Also, at the job level, we are able to target specific folders or/and file types.

At a global level, we can also just exclude specific file extensions.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s