Symantec/Veritas – Backup Exec – Opened Files Options


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.




“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.





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.






We no longer have skipped files.



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



Exclude Properties ( Before )

Here is the empty list


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



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


Exclude Properties ( After )

Here is our completed list




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:

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.