HP 3PAR Recovery Manager Software - Manual (Page 36)

5. Register the SQL server again with HP 3PAR Recovery Manager Software for SQL.
To register an SQL instance:
1.
Right-click the MS SQL Server node and select Register Server.
NOTE: If backup server and SQL production servers reside on different networks, the HP
3PAR Recovery Manager for Microsoft SQL Server Register window may not display all of the
available SQL servers.
In addition, the displayed list of SQL servers can vary depending on factors such as network
traffic, timeouts, routers, lost broadcasted packets, and other network issues.
NOTE: In Microsoft SQL 2012, Microsoft SQL 2012 R2, or Microsoft SQL 2008, sysadmin
role is not selected for NT account (NT AUTHORITY\SYSTEM ), by default. For HP 3PAR
Recovery Manager for SQL to work, user must explicitly configure the sysadmin role if it is not
enabled.
2. Depending on whether the HP 3PAR Recovery Manager for Microsoft SQL Server Register
window displays the SQL server to be registered, do one of the following:
•
If the list displays the SQL server to be registered, Recovery Manager discovered the
server instance, Do as follows:
a.
Select the Register checkbox for the server instance.
b. Click OK.
•
If the list does not display the SQL server to be registered, you must manually register the
instance. To manually register the instance:
1.
In the Server Name text box, enter the SQL server name and instance name. Use the
format SQLServerName\instanceName as follows:
◦ To register the default instance, either enter the SQL server name only, or enter
the SQL server name and default, separated by a backslash.
For example, Aztec or Aztec\default.
◦ To register a named instance, enter the SQL server and instance name, separated
by a backslash. Multiple server names can be added simultaneously by
seperating server names with a comma (,).
To register a named instance, enter the SQL server and instance name, separated
by a backslash.
36 Using the Recovery Manager GUI