Create a SQL Restore Job Definition

Restore SQL environments from snapshots using a SQL Restore job definition.. Your SQL clones can be utilized and consumed instantly through IBM Spectrum Protect Plus Instant Disk Restore jobs. IBM Spectrum Protect Plus catalogs and tracks all cloned instances. Instant Disk Restore leverages iSCSI or fibre channel protocols to provide immediate mount of LUNs without transferring data. Snapshotted databases are cataloged and instantly recoverable with no physical transfer of data.

The following restore modes are supported: Instant Access mode, Test mode, and Production mode. In Instant Access mode, no further action is taken after mounting the share. Users can perform any custom recovery using the files in the vSnap volume. An Instant Access restore of an Always On database is restored to the local destination instance. In Test mode, the agent spins up a new database using the data files directly from the vSnap volume. In Production mode, the agent first restores the files from the vSnap volume back to primary storage and then spins up the new database using the restored files.

BEFORE YOU BEGIN:

  • Create and run a SQL Backup job. See Create a SQL Backup Job Definition.
  • Review SQL requirements. See Microsoft SQL Server Requirements.
  • Before an IBM Spectrum Protect Plus user can perform backup and restore operations, roles and resource groups must be assigned to the user. Grant users access to resources and backup and restore operations through the Accounts pane. See Access.

MICROSOFT SQL SERVER CONSIDERATIONS:

To create a SQL Restore job definition:

  1. From the navigation menu, expand Manage Protection, then expand Applications. Expand SQL, then click Restore.
  2. In the Restore pane, review the available restore points of your SQL servers. Use the search function to search for available restore points and toggle the displayed restore points through the View filter. Available options include Standalone/Failover Cluster and Always On.
  3. To select the latest restore point, click Add to Restore List Add to Restore List icon at the resource level. Then, from the Select a site drop-down menu, select the site associated with the backup storage server you want to recover from. To restore a specific restore point from a specific site, expand a resource in the Restore pane, then click the Add to Restore List Add to Restore List icon icon associated with the restore point. Note that adding a combination of latest restore points and specific restore points to the Restore List is not supported. Click the Remove Remove icon icon to remove restore points from the Restore List.
  4. To run the job now using default options, click Restore. To schedule the job to run using default options, click Manage Jobs and define a trigger for the job definition.
  5. To edit options before creating the job definition, click Options. Set the job definition options.
  6. Destination
  7. Set the restore destination.
  8. Restore to original instance - Select to restore to the original instance.
  9. Restore to primary instance - When performing restore operations in a SQL Always On environment, select to restore the database to the primary instance of the Always On Availability Group and add the database back to the Always On Availability Group.
  10. Restore to alternate instance - Select to restore to a local destination different from the instance, then select the alternate location from available servers. When performing restore operations in a SQL Always On environment, the database is restored to a secondary instance and left in a restoring state.
  11. Click the New Database Name field to enter an optional alternate name for the database.
  12. Restore Type
  13. Set the SQL Restore job to run in Test, Production, or Instant Access mode by default. Once the job is created, it can be run in Test, Production, or Instant Access mode through the Job Sessions pane.
  14. Recovery Options
  15. Set the recovery options:
  16. No Recovery - Sets the selected database to a "restoring" state. If managing transaction log backups without using IBM Spectrum Protect Plus, you can manually restore log files, and add the database to an availability group, assuming the lsn of the secondary and primary database copies meet the criteria. The "No recovery" option does not support Production mode restores to SQL Always On groups.
  17. Recover until end of backup - Restore the selected database to the state at the time the backup was created.
  18. Recover until specific point in time - When log backup is enabled through a SQL Backup job definition, point-in-time restore options will be available when creating a SQL Restore job definition.
  19. To configure a point-in-time recovery by a specific date and time, select By Time. Select a date through the calendar interface and a time through the hour and minutes drop-down menus.
  20. To configure a point-in-time recovery by a transaction ID, select By Transaction ID. Enter a transaction ID in the available field, then click Save.
  21. In a standalone restore, IBM Spectrum Protect Plus finds the restore points that directly proceed and follow the selected point-in-time. During the recovery, the older data backup volume and the newer log backup volume are mounted. A temporary restore point is created if the point-in-time is after the last backup. In an Always On restore running in Test mode, the restored database will join the Instance where the Availability Group resides. In an Always On restore running in Production mode, the restored Primary database will be joined to the Availability Group. The Secondary database is restored in “norecovery” mode, and is kept in the target standalone Instance.
  22. Application Options
  23. Overwrite existing database - Enable to allow the restore job to overwrite the selected database. By default this option is disabled.
  24. Maximum Parallel Streams per Database - Set the maximum data stream from the backup storage per database. This setting applies to each database in the job definition. Note that multiple databases can still be restore in parallel if the value of the option is set to 1. Multiple parallel streams may improve restore speed, but high bandwidth consumption may affect overall system performance.
  25. Advanced Options
  26. Set the advanced job definition options:
  27. Run cleanup immediately on job failure - Enable to automatically clean up allocated resources as part of a restore if the recovery fails.
  28. Allow session overwrite - Select this option to replace an existing database with the same name during recovery. When an Instant Disk Restore is performed for a database and another database with the same name is already running on the destination host/cluster, IBM Spectrum Protect Plus shuts down the existing database before starting up the recovered database. If this option is not selected, the restore job fails when IBM Spectrum Protect Plus encounters an existing running database with the same name.
  29. Continue with restores of other selected databases even if one fails - Toggle the recovery of a resource in a series if the previous resource recovery fails. If disabled, the Restore job stops if the recovery of a resource fails.
  30. Protocol Priority (Instant Access only) - If more than one storage protocol is available, select the protocol to take priority in the job. Available protocols include iSCSI and Fibre Channel.
  31. Script Settings
  32. In the Pre-Script and/or Post-Script section, select an uploaded script. Select the Use Script Server check box to select a script server where the script will run. To select an Application Server where the script will run, clear the Use Script Server check box. Scripts and script servers are configured through the Jobs and Monitoring > Script pane. See Configure Scripts.
  33. Pre-scripts and post-scripts are scripts that can be run before or after a job runs at the job-level. Batch and PowerShell scripts are supported.
  34. Continue job/task on script error - When enabled, if a Pre-script completes with a non-zero return code, the backup or restore is attempted and the Pre-script task status returns COMPLETED. When disabled, the backup or restore is not attempted, and the Pre-script task status returns FAILED. If a Post-script completes with a non-zero return code, the Post-script task status returns COMPLETED. When disabled, the Post-script task status returns FAILED.
  35. Click Save to save the policy options.
  36. To run the job now, click Restore. To schedule the job click Manage Jobs and define a trigger for the job definition.

 


IBM Spectrum Protect Plus 10.1.2

Licensed Material - Property of IBM Corp. © IBM Corporation and other(s) 2018. IBM is a registered trademark of the IBM Corporation in the United States, other countries, or both. | 8/23/2018