How to use snapshot technology with the SQL Agent
|Article:HOWTO74401|||||Created: 2012-03-02|||||Updated: 2012-03-16|||||Article URL http://www.symantec.com/docs/HOWTO74401|
The SQL Agent supports full snapshot backups using Microsoft's Volume Shadow Copy Service (VSS), a snapshot provider service only available on Windows 2003 or later. The use of snapshot technology can reduce both restore time and backup performance on the server.
When a backup job is submitted that uses snapshot technology, a snapshot of each volume is created, providing a point-in-time record of the data. Backup Exec uses snapshot technology to momentarily suspend write activity to a volume so that a snapshot of the volume can be created. The data is then backed up from the snapshots, and then the snapshots are deleted.
Before you use snapshot technology with the SQL Agent, review the following information:
The following SQL backup options are not supported with snapshot backups:
Article URL http://www.symantec.com/docs/HOWTO74401