CloudByte ElastiStor Recovery Manager for SQL Server (RMSQL) plug-in

Introduction

CloudByte ElastiStor Recovery Manager for SQL Server (RMSQL) plug-in lets you automate backup and restore of the SQL Server and the associated databases that reside on ElastiStor LUN.

You can create snapshot, delete, restore, and list snapshots.

Installing the plug-in

Prerequisites
  • Install Windows Server 2008 R2 SP2 OR Windows Server 2012 as Operating System.
  • Enable .NET framework 3.5.1 features. For details, see Enabling .NET framework.
  • Install .NET Framework 4.0. For details, see Installing .NET framework 4.0.
  • Install or upgrade to Windows PowerShell 3.0. For details, see Installing Windows PowerShell 3.0 .
  • CloudByte ElastiStor is up and running.
  • Mount the iSCSI Storage Volumes to the MSSQL Server. For details, see the section On Windows Server 2008 at Mapping iSCSI LUNs.
  • Install MSSQL Server 2014 as database.

Installation procedures

    1. Get the RMSQL plug-in installation files from CloudByte Technical Support.
    2. Run the execution file setup.
    3. Follow the onscreen instructions on the Wizard and complete the installation.
install_RMSQL

Using the plug-in

Function Command
Load PowerShell SQL Module: Run this command first when you invoke PowerShell. If you change the default path, ensure that you modify the command accordingly. Import-Module ‘C:\Program Files\CloudByte\RMSQL\PSSql.dll’
Set REST server details to the registry: Run this command to set the REST server details into the registry. Set-RestServer -IPAddress <IP Address of t RestServer IP > -RestAPIKey <API Key of the RestServer>
Set Backup Properties: Run this command to set the location in the registry to store backup data. Set-BackupProperties –BackupInfoPath <Path where you want to save BackupInformation>
Show REST Server details: Run this command to display the REST Server settings. Show-RestServer
Show Backup properties:Run this command to see the location where backup files are stored. Show-BackupProperties
Create Snapshot: Run this command to take new point in time snapshot of the databases in the SQL Server. That is, the backup of the SQL Server Components.
  • For Windows authentication:
    new-snapshot -inst <instance name> -d <database name> -ntauth 
  • For SQL authentication:
    new-snapshot -inst <instance name> -d <database name> -usr <username> -pwd <password>
Restore Snapshot of the databases in the SQL server: Run this command to restore snapshot of the Databases in the SQL Server.
  • For Windows authentication:
    restore-snapshot -Inst <instance name> -d <database name> -snapshot <snapshot name> -ntAuth 
  • For SQL authentication:
    restore-snapshot -Inst <instance name> -d <database name> -snapshot <snapshot name> -usr <username> -pwd <password>
List Snapshot: Get details of the snapshots of databases in the SQL server. Also, determine the snapshot that you want to restore. Get-Snapshots -inst <instance name> -d <database name>
Delete Snapshot: Run this command to delete the snapshots of databases in the SQL server.
  • For Windows authentication:
    Remove-Snapshot -inst <instance name> -d <database name> -SnapshotName <string> - ntAuth 
  • For SQL authentication:
    Remove-Snapshot -inst <instance name> -d <database name> -SnapshotName <string> - usr <username> -pwd <password>
    

Parameters
Abbreviation Usage
-inst Instance name of SQL Server
-d Comma-separated list of database names.
-ntauth Windows authentication
-usr Username in the case of SQL Server Authentication.
-pwd Password in the case of SQL Server Authentication.
-snapshot Snapshot Name to be provided as available in the BackupinfoPath folder(under InstanceName folder)
-norecovery Used when the database has to be left in Restoring state(to allow the user to run additional logs).
-SnapshotName Name of snapshot to be deleted (as fetched in get-snapshots)

FAQs

How will I uninstall the plug-in?

On Windows Server 2008
    1. Go to Program Files (Start > Program Files).
    2. Select RMSQL.
    3. Click Uninstall RMSQL.
    4. At the prompt, click Yes.
    5. In the following screen, select Remove RMSQL_COM.
uninstall_RMSQL
  1. Click Finish
  2. Follow the onscreen instructions on the Wizard and complete the uninstallation.
On Windows Server 2012
  1. Go to Start.
  2. Search for Uninstall RMSQL.
  3. Select Uninstall RMSQL.
  4. At the prompt, click Yes.
  5. In the following screen, select Remove RMSQL_COM.
  6. Click Finish.
  7. Follow the onscreen instructions on the Wizard and complete the uninstallation.

What are the procedures for restoration in a clustered environment?

Restoration involves procedures to be performed on both the Nodes in the Cluster.

Step Primary Node Secondary Node
1  

Stop the Cluster service. Do the following:

  1. In the Run dialog, type services.msc and then click OK.
  2. Navigate to Cluster Service.
  3. In the left pane, click Stop.
2  

Stop the SQL Server service. Do the following:

  1. In the Run dialog, type services.msc and then click OK.
  2. Navigate to SQL Server Instance Name.
  3. In the left pane, click Stop.

 

3   Disconnect the iSCSI LUN using iSCSI Initiator tool.
4 Run the following command to initiate the restore process: restore-snapshot -Inst <instance name> -d <database name> -snapshot <snapshot name> -ntAuth
5  

Go to SQL server management console.

Browse the database and  its tables.

 
6  

Start the Cluster service. Do the following:

  1. In the Run dialog, type services.msc and then click OK.
  2. Navigate to Cluster Service.
  3. In the left pane, click Stop.
7  

Start the SQL Server service. Do the following:

  1. In the Run dialog, type services.msc and then click OK.
  2. Navigate to SQL Server Instance Name.
  3. In the left pane, click Stop.

Limitations

Sector size cannot exceed 4k while creating the volumes for

  • SQL server installation
  • Database creation