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

Creating dynamic disk groups

Create one or more dynamic disk groups.

Note:

Disk groups must be of a Storage Foundation 4.0 or later version. You must upgrade any disk groups created using an earlier version of Volume Manager for Windows before implementing SFW snapshot solutions. Quick Recovery snapshots are supported only on volumes belonging to an SFW dynamic disk group. They are not supported on volumes belonging to a Microsoft Disk Management Disk Group. For more information, see Storage Foundation Administrator's Guide.

Note:

If User Access Control (UAC) is enabled on Windows Server operating systems, then you cannot log on to VEA GUI with an account that is not a member of the Administrators group, such as a guest user. This happens because such user does not have the "Write" permission for the "Veritas" folder in the installation directory (typically, C:\Program Files\Veritas). As a workaround, an OS administrator user can set "Write" permission for the guest user using the Security tab of the "Veritas" folder's properties.

To create a dynamic disk group from the VEA console

  1. Launch Veritas Enterprise Administrator from the Apps menu on the Start screen.

    Select a profile if prompted.

  2. Click Connect to a Host or Domain and in the Connect dialog box, specify the host name and click Connect.

    For the local system you can specify localhost.

  3. If prompted to do so, specify the user name, password, and domain for the system.
  4. In the tree expand the system name and expand the storage agent.
  5. Right-click Disk Groups, and click New Dynamic Disk Group.
  6. On the Welcome screen of the New Dynamic Disk Group Wizard, click Next.
  7. Enter a name for the disk group (for example, billing_DG).

    Note:

    A dynamic disk group name is limited to 18 ASCII characters. It cannot contain spaces, slash mark (/), backslash (\), exclamation point (!), angle brackets (< >), or equal sign (=). Also, a period cannot be the first character in the name.

  8. For an off-host or cluster environment, choose from the following:

    • For a cluster environment, check the Create cluster group check box.

    • For an off-host environment, check the Add private group protection check box.

  9. Select the appropriate disks in the Available disks list and click the Add button to move them to the Selected disks list.
  10. Click Next.
  11. Click Next to upgrade the selected disks.
  12. Click Finish to create the new disk group.

To create a dynamic disk group from the command line

  • Type the following command:

    > vxdg -gbilling_DG init Harddisk1 Harddisk2 Harddisk3

    where -gbilling_DG is the name of the dynamic disk group you want to create and Harddisk1, Harddisk2, and Harddisk3 are the disks included in the dynamic disk group.

    For the complete syntax of the vxdg init command, see the Storage Foundation Administrator's Guide.