InfoScale™ 9.0 Storage Foundation Quick Recovery Solutions Guide for Microsoft SQL Server - Windows

Last Published:
Product(s): InfoScale & Storage Foundation (9.0)
Platform: Windows
  1. Introducing Quick Recovery for SQL Server
    1.  
      About Quick Recovery snapshot solutions
    2.  
      About snapshot-assisted backups
    3.  
      Advantages of Quick Recovery snapshots
    4.  
      Quick Recovery process
    5. Methods of implementing Quick Recovery snapshots for SQL Server
      1.  
        About the Quick Recovery Configuration Wizard
      2.  
        About the VSS Snapshot Scheduler Wizard
      3.  
        About the VSS Snapshot and Snapback wizards and the vxsnap utility
    6. About the components used in Quick Recovery
      1.  
        FlashSnap and FastResync
      2. Integration with Microsoft Volume Shadow Copy Service
        1.  
          VSS framework
        2.  
          VSS process
    7.  
      VCS, Microsoft clustering, and Volume Replicator considerations
    8.  
      About the Solutions Configuration Center
    9.  
      Starting the Configuration Center
    10.  
      Solutions wizard logs
  2. Preparing to implement Quick Recovery for SQL Server
    1.  
      Tasks for preparing to implement Quick Recovery for SQL Server
    2. Reviewing the prerequisites
      1.  
        Storage requirements and best practices
      2.  
        Configuration requirements and best practices
    3.  
      Reviewing the configuration
    4. Configuring SQL Server storage with Storage Foundation for Windows
      1.  
        Creating dynamic disk groups
      2.  
        Creating dynamic volumes
      3.  
        Pointing the databases and log paths to the SFW volumes
  3. Implementing Quick Recovery for SQL Server with the configuration wizard
    1. About the Quick Recovery Configuration Wizard
      1.  
        Backup types for snapshot sets
      2. About snapshot templates
        1.  
          Templates and multiple components
        2.  
          Templates and schedule start dates
    2.  
      Tasks for implementing snapshot sets with the configuration wizard
    3.  
      Reviewing the prerequisites
    4. Scheduling SQL Server snapshot sets
      1.  
        System Selection panel details
      2.  
        Instance Selection panel details
      3.  
        Mount Details panel details
      4.  
        Synchronizing Schedules panel details
      5.  
        Template Selection panel details
      6.  
        Number of Snapshot Sets panel details
      7.  
        Snapshot Volume Assignment panel details
      8.  
        Snapshot Schedule panel details
      9.  
        Specifying snapshot schedule details
      10.  
        Summary panel details
      11.  
        Template Implementation panel
  4. Scheduling or creating an individual snapshot set for SQL Server
    1.  
      About scheduling or creating an individual snapshot set
    2.  
      Tasks to schedule a new snapshot set
    3.  
      Tasks to create a one-time snapshot set
    4.  
      Reviewing the prerequisites
    5.  
      Preparing the snapshot mirrors
    6.  
      Scheduling a new snapshot set
    7.  
      Creating a one-time snapshot set
    8. Refreshing a snapshot set
      1.  
        Reattaching the split-mirror snapshots
  5. Maintaining or troubleshooting snapshots
    1.  
      Viewing the status of scheduled snapshots
    2.  
      Troubleshooting scheduled snapshots
    3.  
      Deleting or modifying schedules
    4.  
      Synchronizing schedules after adding a cluster node
  6. Recovering a SQL Server database
    1.  
      About recovering a SQL Server database
    2.  
      Tasks for recovering a SQL Server database
    3.  
      Prerequisites for recovering a SQL Server database
    4.  
      Types of recovery
    5.  
      Recovering using snapshots without log replay
    6.  
      Recovering using snapshots and log replay
    7.  
      Restoring snapshots and manually applying logs
    8. Recovering missing volumes
      1. Preparing for the recovery
        1.  
          Reassigning the drive letter or mount points of the missing volumes to the snapshot volumes
        2.  
          Replacing hardware and adding disks to the dynamic disk group
      2.  
        Performing the recovery
    9.  
      Post-recovery steps
    10.  
      Vxsnap restore command reference
  7. Vxsnap utility command line reference for SQL Server
    1.  
      About the vxsnap utility
    2. Vxsnap keywords
      1.  
        vxsnap prepare
      2.  
        vxsnap create
      3.  
        vxsnap reattach
      4.  
        vxsnap restore

Troubleshooting scheduled snapshots

When scheduling snapshots using the Quick Recovery Configuration Wizard or the VSS Snapshot Scheduler Wizard, you can use the information in the following table to help avoid problems or troubleshoot situations.

Situation

Resolution

Snapshots do not occur on a scheduled date.

The date may have been excluded under "Specific Dates" on the schedule. Excluding a date takes precedence over other days scheduled.

A snapshot is not taken on the date that you create the schedule, although that date is specified as the "Schedule takes effect on date".

The date shown in the Schedule takes effect on field is used as a run day only if no other run days are specified. If you specify other run days, the schedule starts running on the earliest day specified.

If you want the current date included in a schedule, specify it as an Include date on the Specific Dates tab.

A scheduled snapshot does not occur for an imported template schedule.

If you import a template that uses the current date as the "takes effect on" date, but part of the schedule cannot be implemented for the current date, the effective date is shifted to the following day.

For example, if the schedule includes two daily snapshots, one in the morning and one at night, and you import the schedule in the afternoon, neither of the snapshots occur on the current date. Both occur the following day.

While running the Quick Recovery Wizard to modify template settings, the existing settings are not displayed.

If a scheduled snapshot operation is occurring on the selected object at the same time that you select the object in the wizard, the wizard is temporarily unable to display the existing settings.

You can try running the wizard later.

A schedule is unavailable to be edited in the Quick Recovery Wizard.

Expired schedules cannot be edited.

Instead, delete the expired schedule and add a new one.

You want to use the VSS Scheduler wizard but the Applications node is not shown in the VEA.

You may need to refresh the VEA display to see the node.

For SQL, you must manually start the SQL Server VSS Writer Service. Then right-click the Storage Agent node in the VEA and click Refresh.

Drive letters assignments for snapshot volumes do not occur.

If time elapses between when you use the wizard to assign drive letters and when the snapshot operation occurs, a drive letter you assigned may become unavailable. When this occurs, the snapshot operation is performed, but no drive letters are assigned.

You can assign or change drive letters or mount paths in Veritas Enterprise Administrator.

A scheduled snapshot fails after you have done a manual snapback (reattach) of one or more of the snapshot volumes in the snapshot set.

When a snapback is done manually for a volume rather than by using the VSS Snapback wizard or allowing the scheduler to handle it, the XML metadata file is not deleted. To take the next scheduled snapshot, the scheduler attempts to reattach all the volumes specified in the XML metadata file and fails because one or more are already reattached. Therefore, the snapshot also fails.

To ensure that the next scheduled snapshot works correctly, use the VSS Snapback wizard (or the vxsnap utility) to reattach using the XML file.

Two databases are on the same volume. You run the Quick Recovery wizard to schedule the first database. You then run it again to schedule a snapshot for the second database on the same disk. But the mirror preparation for the first database is not yet complete.

The following problems can occur:

  • When running the wizard, the second time, it does not update the available disk space shown for the disk where the first snapshot is scheduled.

  • Mirror preparation for the second database fails.

You can choose from the following ways to avoid these problems:

  • Include both databases in the snapshot when running the wizard the first time.

  • Select a different disk for the second snapshot mirror when running the wizard the second time.

  • Wait for the mirror preparation for the first snapshot to finish before running the wizard to schedule the second snapshot.

In addition, when troubleshooting, you may want to review the following logs.

If a schedule fails, check the scheduler service logs in the following folder:

C:\Program Files\Veritas\Veritas Volume Manager\logs\SchedService.log

If a snapshot fails, check the VxSnap.log file in the following folder:

C:\Program Files\Veritas\Veritas Volume Manager\logs

Quick Recovery Configuration wizard log files are located in the following path:

C:\ProgramData\Veritas\winsolutions\log