Managing Data Protection for SQL Server installations remotely

From a single Data Protection for SQL Server installation you can manage all of the Data Protection for SQL Server installations in your enterprise.

Before you begin

Your system must run Microsoft Windows 2008 or later versions, PowerShell 3.0 or later, and Data Protection for SQL Server. On Windows 2012 and later versions, PowerShell version 4.0 is installed by default. For information about downloading, installing, and enabling Windows PowerShell, see this web page: Microsoft Windows Management Framework 3.0 Downloads

Procedure

Enable remote management for Data Protection for SQL Server installations by issuing the following command:
```
Enable-PSRemoting -force
```
Add the Data Protection for SQL Server servers to the trusted hosts list by issuing the following command:
```
Set-Item WSMan:\localhost\Client\TrustedHosts -Value remote_server_name -Force
```
After you make configuration changes, restart the winrm service by issuing the following command.
```
Restart-Service winrm
```

Adding remote systems

You can add remote systems in MMC.

Procedure

From Microsoft Management Console (MMC), in the Actions pane, click Manage Computers.
Verify that the local system is listed in both the Tree Nodes and Computers panes.
From the Tree Nodes pane, click the add icon. The icon is green and resembles the symbol for addition.
Type the name and description for the new tree node.
From the Computers pane, click the add icon. The computers that you add are associated with the tree node that you are creating. If you add only one computer, the tree node type can be either Dashboard or Group. If you add more than one computer, the tree node type is Group. If you add only one computer, from the Tree Nodes pane, you can toggle between the Dashboard and Group types.
Type the system name and a description. For systems that are not in the domain, provide the fully qualified address. Alternatively, to select a system that is based on another system in the domain or to read a list of computers from a file, on the Computers pane, click Import. Clicking Import. displays a dialog called Add Computers. From the Add Computers dialog, there are two tabs: Active Directory and Import. To complete the Add Computers dialog window entries, complete the following steps:
1. For the Active Directory tab, complete these fields
  Domain
  
  The current domain is displayed. The domain cannot be changed.
  
  Location
  
  The organizational unit that is used to search for computers. The default value is displayed.
  
  Name
  
  By default, the wildcard character (*) is displayed. You can leave the default value or enter a specific name.
  
  Account
  
  The current account is displayed. If you want to use a different account, click Search to search the domain for other computers. The Search capability is enabled only when the Location and Name fields have values.
2. For the Import tab, browse to find a comma-separated values (.CSV) file that contains computer entries. After you find a .CSV file and click Import, the contents of the .CSV file are read as entries and are added to the list. The following .CSV file is an example of a valid .CSV file for the import activity:
```
NewNode1,Group1,CurrentUser,Test node 1 
NewNode2 
NewNode3,,Description of NewNode3 
NewNode4,Group2,CurrentUser,Test node 4 
```
  The first column (the node name) is required. The other data columns are optional. The list is processed by position. For the group, if a group does not exist, the group is created.
From the Computers pane, click Test Connection. The test status is reported in the Message column of the Computers table.
Click OK to close the Manage Computers window.
Verify that the tree node is listed in the navigation tree. The remote node does not have all of the functionality available for local systems. For example, entries for learning, online support, and favorite links are not displayed.
For tree node type Dashboard, the main window displays the Protect, Recover, and Automate tabs. For tree node type Group, the main window displays the Group Dashboard, Group Reports, and Group Commands tabs.
After you add systems, you can remove (delete) the systems. You can also select the system to edit the properties, including tree node type, that you entered when you added the system. If you want to change the order of the systems that are displayed in the navigation tree, use the GUI controls from the Manage Computers window.