How to create a client resource to backup a standalone MS SQL server

Summary: How to create a client resource to backup a standalone MS SQL server.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

The aim of this article is to demonstrate how to:
  1. Create SQL clients manually.
  2. Register an MS SQL Server remote agent running on an SQL Server.
  3. Create SQL clients using the wizard.

First: How to create SQL clients manually
To create SQL clients manually, apply the following steps:
  • Go to the  Protection  tab in the NMC, right click on  Clients  and then choose  New . The  Create Client  window will appear.
General tab:
  • In the  Name  attribute, write down the FQDN of the client.
  • In the  Comment  attribute, if you want, you can write down a brief description about the client you are creating like for example: SQL Client
  • In the  Save set  attribute, write down the save set(s) you want to backup.
  • In the  Protection group list  attribute, add the client to the groups you want.
  • You can set also the  Retention policy ,  Client direct ,  Scheduled backup ,  Pool ,  Schedule  and  Directive  attributes for this client from the  General  tab.
Apps & Modules:
  • In the  Remote user  and  Password  attributes, write down the credentials of a user that has enough privileges to back up the desired save set(s).
  • In the  Backup command  attribute, write down  nsrsqlsv . If you wish to specify more options with this command, check  EMC NetWorker Module for Microsoft for SQL VDI  user guide.
  • In the  Application information  attribute, specify the options you want. To read more about that, check  EMC NetWorker Module for Microsoft for SQL VDI  user guide.
Globals (2 of 2)
  • Set the  Remote Access  attribute to an appropriate value. You can set it to *@*.
  • In the  Storage Nodes  attribute, write down the name of the storage nodes that are going to back up this client.
  • When you are done with the configuration of the client, Click on  OK .
 
Second: How to register an MS SQL Server remote agent running on an SQL Server
To register an MS SQL Server remote agent running on an SQL Server, apply the following steps:
  • Go to the client itself and open a command prompt with admin. privileges and run the following command:
    nsrnmsqlra -i

Third: How to create SQL clients using the wizard
To create SQL clients using the wizard, apply the following steps:
  • Go to the  Protection  tab in the NMC, right click on clients, and then choose  New Client Wizard . The  Client Backup Configuration  window will appear.
  • In the  Name  attribute, write down the FQDN of the client. Write down also a description for this client in the  Comment  attribute if you want; and then the client to a group.
  • In the  Type  attribute, select  Traditional . Then click on  Next .
  • From the  Available Applications  box, select  SQL Server . Then click on  Next .
  • Set the  Remote Access  attribute to an appropriate value. You can set it to *@*. Set also the other attributes you will find in the  Select the NetWorker Client Properties  page to appropriate values. Then click on  Next .
  • Then select the DB, instance or Availability Group you want to backup from the  Select the Backup Objects  page. Then click on  Next .
  • Then enter the credentials for a user that has enough privileges to back up the save sets you specified in the  Select the Backup Objects  page.
  • In the  Specify the Backup Options  page, select the options you want to use. To read more about the option you can choose to use, check  EMC NetWorker Module for Microsoft for SQL VDI  user guide.
  • In the  Client Configuration Summary  page, review the summary before you. After reviewing it, click on  Create .
  • After the creation of the client completes successfully, click on  Finish .

Additional Information

Check the following video (https://www.youtube.com/watch?v=6-Yo3xd8cEI). It demonstrates the steps above.

Affected Products

NetWorker Module for Microsoft

Products

NetWorker, NetWorker Series, NetWorker Management Console, NetWorker Module, NetWorker Module for Microsoft
Article Properties
Article Number: 000022529
Article Type: How To
Last Modified: 21 جمادى الآخرة 1447
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.