DB Administration with Era

We will now see how to perform normal database admin task with Era.

In this lab you will Administor your MSSQL DB

Register Your Database

  1. In Era, select Databases from the dropdown menu and Sources from the lefthand menu.

    ../../../_images/160.png

  2. Click + Register and fill out the following fields:

    • Engine - Microsoft SQL Server

    • Database is on a Server that is: - Registered

    • Registered Database Servers - Select your registered Initials-MSSQL VM

    ../../../_images/249.png

    • Unregistered Databases - Select SampleDB

    • Database Name in Era - Initials-LABSQLDB

    ../../../_images/337.png

    • Recovery Model - Full

    • Manage Log Backups with - Era

    • Name - Initials-MSSQL_TM

    • SLA - DEFAULT_OOB_BRASS_SLA (no continuous replay)

    ../../../_images/419.png

  3. Click Register

  4. Select Operations from the dropdown menu to monitor the registration. This process should take approximately 5 minutes.

Snapshot Your Database

Before we take a manual snapshot of our Database, lets write a new table into SampleDB

Write New Table Into Database

  1. RDP/Console into your Initials-MSSQL VM

  2. Open SQL Server Managment Studio (SSMS), and Connect using Windows Authentication.

  3. Right-Click on SampleDB and Select New Query.

    ../../../_images/523.png

  4. Execute the following SQL Query:

    select * into dbo.testlabtable from sales.orders;
    ../../../_images/615.png

  5. Verify the new table is there by doing a refresh on Tables.

Take Manual Snapshot of Database

  1. In Era, select Databases from the dropdown menu and Sources from the lefthand menu.

  2. Click on the Time Machine for your Database Initials-MSSQL_TM

    ../../../_images/714.png

  3. Once that is complete, click Actions > Snapshot.

    ../../../_images/814.png

    • Snapshot Name - Initials-MSSQL-1st-Snapshot

    ../../../_images/914.png

  4. Click Create

  5. Select Operations from the dropdown menu to monitor the registration. This process should take approximately 2-5 minutes.

Clone Your Database Server & Database

  1. In Era, select Time Machines from the dropdown menu and select Initials-MSSQL_TM

  2. Click Actions > Clone Database > Single Node Database.

    • Snapshot - Initials-MSSQL-1st-Snapshot (Date Time)

    ../../../_images/1013.png

    • Database Server - Create New Server

    • Database Server Name - Initials-MSSQL_Clone1

    • Compute Profile - DEFAULT_OOB_COMPUTE

    • Network Profile - Primary-MSSQL-Network

    • Administrator Password - Nutanix/4u

    ../../../_images/1116.png

    • Clone Name - Initials-LABSQLDB_Clone1

    • Database Name on VM - SampleDB_Clone1

    • Instance Name - MSSQLSERVER

    ../../../_images/1215.png

  3. Click Clone

  4. Select Operations from the dropdown menu to monitor the registration. This process should take approximately 30-50 minutes.

Delete Table and Clone Refresh

There are times when a table or other data gets deleted (by accident), and you would like to get it back. here we will delete a table and use the Era Clone Refresh action from the last snapshot we took.

Delete Table

  1. RDP/Console into your Initials-MSSQL_Clone1 VM

  2. Open SQL Server Managment Studio (SSMS), and Connect using Windows Authentication.

  3. Expand SampleDB_Clone1 > Tables, Right-Click on dbo.testlabtable and Select Delete and OK.

Clone Refresh

  1. In Era, select Databases from the dropdown menu and Clones from the lefthand menu.

  2. Select the Clone for your Database Initials-LABSQLDB_Clone1 and Click Refresh.

    • Snapshot - Initials-MSSQL-1st-Snapshot (Date Time)

  3. Click Refresh

  4. Select Operations from the dropdown menu to monitor the registration. This process should take approximately 2-5 minutes.

Verify Table is Back

  1. RDP/Console into your Initials-MSSQL_Clone1 VM

  2. Open SQL Server Managment Studio (SSMS), and Connect using Windows Authentication.

  3. Expand SampleDB_Clone1 > Tables, verify dbo.testlabtable is there.