About backing up VSS-aware databases

  • Modified Date:
  • Article ID:000056011

Description

About backing up VSS-aware databases

Symantec System Recovery can co-exist with Microsoft VSS (Volume Shadow Copy Service) to automate the process of backing up VSS-aware databases such as the following;

  • Exchange Server 2003 SP1 or later

  • SQL Server 2005 or later

  • Windows Server 2008-based domain controller or later

  • Oracle 9i or later
Note:
Licensing Symantec System Recovery on client computers does not give users any rights to use VSS. VSS must be licensed separately from Microsoft, and users must conform to any license agreement or documentation that accompanies VSS.
VSS-aware databases are auto-enabled and cannot be turned off.

About backing up non-VSS-aware databases
VSS lets IT administrators create a shadow copy backup of drives on a server. The shadow copy includes all files (including open files).
When a backup job starts, Symantec System Recovery alerts the VSS that a recovery point is about to be created. VSS then communicates this information to the VSS-aware databases and puts them into a quiesced (sleep) state. (Backup Exec System Recovery always attempts to communicate with VSS if it is installed on a desktop or server and tries to provide VSS with information to quiesce databases.)
While in this quiesced state, the databases continue to write to transaction logs, and Symantec System Recovery takes an instantaneous snapshot that also includes any open files. When the snapshot is complete, VSS is notified, the databases are activated, and the transaction logs continue writing to the database. (To verify that there are no errors and that VSS is running, you should check the Microsoft error logs.)
While the recovery point is being created from the snapshot, the databases and applications return to an active state and continue to write data.This kind of integration means that you can back up business-critical databases at anytime during the day without affecting productivity.

Additional points for backing up and restoring VSS-aware databases include the following:
  • Symantec System Recovery supports Exchange Server 2003 SP1 and later, which implements VSS technology. If the database load is heavy, the VSS request might be ignored.

  • Run backups during the lightest load time.

  • Additional backup applications are not needed to run Symantec System Recovery with Exchange databases.

  • Make sure that you have installed the latest service packs for your given database. .

  • Symantec System Recovery prevents VSS snapshots from occurring during the time the Symantec System Recovery is creating a recovery point.

  • If a full system restore is done from a recovery point, individual files can be restored from a VSS snapshot. However, the recommended restore process is to use Symantec System Recovery to mount the recovery point file as a virtual drive (using the Recovery Point Browser).

  • After a full system restore from a Symantec System Recovery recovery point, a VSS snapshot that was taken prior to the date and time of the Symantec System Recovery snapshot can no longer be used to restore the entire system.

Warning:
Database corruption may occur if the computer is low on hard disk space when you are rebuilding a database at the same time you are running a backup. To avoid database corruption, you should quiesce the database before backing it up, and you should not rebuild or restore the database at the same time that you are backing it up. Finally, to avoid possible conflict, Symantec System Recovery does not let you take VSS snapshots and Symantec System Recovery snapshots at the same time.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)