Microsoft provides a SQL Server VSS Writer that permits backup solutions such as Plug‑in for SQL Server to copy SQL Server data while SQL Server is running. VSS-based backups do not negatively affect SQL Server’s performance or stability.
A VSS backup using Plug‑in for SQL Server includes the steps outlined in the following topics.
IMPORTANT: Before initiating VSS backups, verify that the SQL Server VSS Writer service is running on the SQL Server. The SQL Server VSS Writer is automatically installed with SQL Server. However, the service is not enabled to start automatically. For VSS backups, start this service from the Windows Services panel — Start > Control Panel > Administrative Tools > Services. Quest recommends that you set the Startup Type for this service to Automatic. You can define a VSS backup job regardless of the state of this service. However, the job fails if it is run while the SQL Server VSS Writer service is not running. The log for the failed backup job contains a message stating “Please ensure the SQL Server Writer service is started.” |
Backup Selection Sets are essential for Incremental and Differential Backups. Create the Backup Selection Set during a Full Backup, and use it for Full, Incremental, and Differential Backups. The backup job reports an error if you do not use a Selection Set for the Incremental or Differential Backup. For more information, see the Quest NetVault Backup Administrator’s Guide.
1 |
2 |
In Job Name, specify a name for the job. |
3 |
4 |
In the list of plug-ins, open Plug‑in for SQL Server, and then open the All Instances node to view the individual instances. |
5 |
The next step involves creating the Backup Options Set or selecting an existing one.
1 |
2 |
In the Backup Method section on the SQL Server Backup Options tab, select Use Volume Shadow Copy Services (VSS). |
3 |
In the Backup type section, select the applicable option: |
4 |
In the Snapshot Options section, complete the following: |
• |
Backup Files to Storage: This option, which is selected by default, copies the selected data from snapshots to a storage device. The plug-in uses a VSS provider to create persistent or non-persistent snapshots on the client, and copies the selected data from the snapshot, or snapshots, to the storage device. |
• |
Retain Snapshot as Persistent: To retain persistent snapshots on a disk array, select this check box. |
• |
If the Backup Files to Storage and Retain Snapshot as Persistent check boxes are both selected, the plug-in copies the selected files to a storage device and adds the snapshot information to the backup index. |
• |
If you clear the Backup Files to Storage check box and select this check box, the plug-in writes only the index entries to the backup stream and creates persistent snapshots on the disk array. |
• |
Discard After: If you selected the Retain Snapshot as Persistent check box and you want to delete persistent snapshots from a disk array after a specified period, select this check box and complete the expiration fields. |
NOTE: To use the Retain Snapshot as Persistent and Discard After options, the SQL Server that you back up must reside on a NetVault Backup-supported disk array and the vendor’s hardware-based VSS provider must be in place. For more information, see Understanding snapshot-based backups. |
5 |
In the VSS Backup Options section, select Use multiple snapshots to limit demands on system resources. |
NOTE: You must select the option Use multiple snapshots to limit demands on system resources for VSS Differential Database backup type if you selected it for VSS Full Database backup type.
The option Use multiple snapshots to limit demands on system resources cannot be combined with the option Retain Snapshot as Persistent. If Use multiple snapshots to limit demands on system resources is selected, snapshots are not retained as Persistent. |
6 |
The final steps include setting additional options on the Schedule, Target Storage, and Advanced Options pages, submitting the job, and monitoring the progress by using the Job Status and View Logs pages. These pages and options are common to all NetVault Backup Plug-ins. For more information, see the Quest NetVault Backup Administrator’s Guide.
1 |
Use the Schedule, Target Storage, and Advanced Options lists to configure any additional required options. |
2 |
TIP: To run a job that you have already created and saved, select Manage Job Definitions in the Navigation pane, select the applicable job, and click Run Now. |
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center