You can restore SQL server data.
Before you begin
You can also restore availability databases
that you backed up with the AlwaysOn node in a SQL
Server 2012 environment. Backups of availability databases can be
restored to any availability replica in an availability group.
Attention: When you restore a
database, existing data is overwritten by the restored data and is
no longer available after the restore is complete.
For AlwaysOn availability databases, ensure
that Tivoli® Storage FlashCopy® Manager is
set up to use an AlwaysOn node name. You can set up the AlwaysOn node
name in the AlwaysOn Node field in the TSM
Node Names page of the Tivoli Storage Manager Configuration
wizard. By default, the AlwaysOn node name is set to the cluster node
name for the SQL Server 2012 Availability Group.
When
restoring availability databases, refer to the following guidelines:
- VSS restore
- Because of a SQL Server limitation, you cannot restore a VSS backup
to an alternative SQL server instance. Therefore, VSS backups must
be restored to the same SQL server instance where the snapshot was
taken.
Procedure
To restore an SQL server database:
- Start the Management Console.
- Select the SQL Server instance
in the tree.
- On the Recover tab for
the SQL instance, specify the type of SQL data to restore:
- Select View: Databases for a list of
SQL database backups that are available for restore.
- Select View: Files for a list of SQL
database backup files that are available for restore.
- For availability databases, click DP
Node Backups to show all AlwaysOn node backups.
The name of the button changes to AlwaysOn Node Backups.
The DP Node Backups / AlwaysOn Node
Backups button toggles between the standard database view
and the availability database view. The label reflects the type of
databases that are displayed in the view.
- Use the Recover tab to
browse and select the databases or files to restore. The following
features are available:
- Search: Fine-tune the list of available databases or files
in the results pane by entering a keyword in the Search field.
- Filter: Use the filter options to narrow the list of items
in the result pane.
- Click Show Filter Options and Add
Row.
- Click the down arrow in the Column Name field
and select an item to filter.
When you click Select All,
all rows that reflect the filter specifications are selected.
- Select an operator in the Operator field.
- Specify a value to filter on in the Value field.
- If you want to filter on extra items, click Add Row.
- Click Apply Filter to filter the items
on the list.
- Backups: You can click Active Backups to
show only active backups, or click All Backups to
show both active and inactive backups.
- Refresh: Click Refresh to update the
view with your changes.
If you
applied a filter, the objects on the server that match the filter
or search criteria are listed in the Recover tab.
The status area indicates the number of items that match the criteria n
of x displayed, where n equals
the number of objects that match the filter criteria, and x is
the number of objects that are retrieved from the server. For example,
"5 of 20 displayed." If you specify refresh
options to further narrow your results, and click Refresh again,
the objects on the server that match the filtered and refresh options
are displayed. Each time that you click Refresh,
another query is run against the Tivoli Storage
Manager server.
- Verify restore options. If the restore options are not
currently displayed, click Show Restore Options.
- Optional: Choose a mode for the
current task:
- Run Interactively: Click this item
to run the current task interactively. This selection is the default.
- Run Scheduled: Click this item to convert
the current action into a scheduled task. When you select this item,
the schedule wizard begins, complete with the command that is required
to complete the task.
- Click Restore or Restore
to Alternate location in the Actions pane
to initiate the restore operation.