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.

Symantec – AntiVirus (10) – Causes slow Computer Response\Busy CPU\High Memory uptake by Rtvscan.exe

Symantec – AntiVirus (10) – Causes slow Computer Response\Busy CPU\High Memory uptake by Rtvscan.exe

One of our servers is always slow.  We have rebuilt it a few times over, but it stays slow.

Finally this morning I decided to Google the offending process, the one with the high memory usage.

Lord and behold, Symantec appears to what appears to be a fix:
http://www.symantec.com/business/support/index?page=content&id=TECH103260&key=51852&actp=LIST

To work around this issue: 
Add the following Key and values to Windows 2003 32-bit and 64-bit Servers:

    1. Start regedit.exe and browse to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsNT\CurrentVersion\Winlogon\Notify
    2. Right-click on the Notify key, and select New > Key.
    3. Type NavLogon for the key.
    4. Right-click on the NavLogon key, and select New > String value.
    5. Type DllName for the String value.
    6. Right-click on the DllName String value, and select Modify.
    7. For the Value data, type C:\WINDOWS\system32\NavLogon.dll (default OS install path)
    8. Click OK and exit the Registry Editor.

After making registry changes, restart the Windows 2003 Server.