IBM Spectrum Protect Plus
Virtualized environment data protection solution

Backup and restore of databases

仅剩    0个名额

已有    0人完成该实验

IBM Spectrum Protect Plus provides efficient data protection and HV solutions for virtual environments and databases. It may be implemented independently or integrated with IBM Spectrum Protect to provide long-term protection, meeting more stringent regulatory requirements.

实验:Backup and restore of databases

304人完成

Experiment content:

IBM Spectrum Protect Plus is a solution that can be used for data protection of VM environments (e.g. VMware and Hyper-V), and enables the data protection and availability for virtual and physical machines of database like Oracle and SQL Server. This experiment will guide you to backup and restore SQL databases quickly with IBM Spectrum Protect Plus. (duration: 20-25mn)

Experiment resources:

IBM Spectrum Protect Plus 10.1.1 software
VMware vSphere 5.5 and VMware vCenter Server 5.5
- Windows Server 2012 R2 with Microsoft SQL Server 2012 (VM)

视频介绍

勋章状态


Lighten Medals

最新动态

xichaoxi

完成实验已获得蓝色勋章!

xichaoxi

limman

完成实验已获得蓝色勋章!

limman

12311262

完成实验已获得蓝色勋章!

12311262

qdong

完成实验已获得蓝色勋章!

ng

完成实验已获得蓝色勋章!

ng

1234262

完成实验已获得蓝色勋章!

挑战:Protect Your Database

127人完成

Challenge Background:

As a backup administrator, you need backup the database using other software every evening in addition to backing up VMs. Now, it is required for you to customize a backup plan for SQL databases and perform a full backup process.

Challenge Goal:

Customize a periodic backup plan for the database "sppdb" in the host (WIN-NTASDQ855H1), where it is required to perform a backup process every evening (22:00) with only one copy retained, and perform a full backup process immediately after such customization.

Challenge Rules:

1. Once the challenge starts, the system will start timing for 30min.
2. Click the "Submit Results" button on the upper left corner after the challenge task is completed.
3. The system evaluates your performance automatically and gives your challenge results and score.
4. Your score is ranked according to your time taken to challenge. The shorter your time is, the higher your rank is.

勋章状态


Lighten Medals

Challenge Ranking List

Rank Nickname Score
583979215 6分13秒
80468165 8分59秒
1913290302 9分4秒
4 phaselin 9分10秒
5 kissxuehua 9分12秒

自由探索:Backup and restore of databases

3人完成

Experiment content:

IBM Spectrum Protect Plus is a solution that can be used for data protection of VM environments (e.g. VMware and Hyper-V), and enables the data protection and availability for virtual and physical machines of database like Oracle and SQL Server. This experiment will guide you to backup and restore SQL databases quickly with IBM Spectrum Protect Plus. (duration: 20-25mn)

Experiment resources:

实验软件:

  • IBM Spectrum Protect Plus 10.1.1 software
    VMware vSphere 5.5 and VMware vCenter Server 5.5
    - Windows Server 2012 R2 with Microsoft SQL Server 2012 (VM)

注意事项

请您先完成教学实验,才能开始挑战实验!

请您先完成挑战实验,才能开启自由实验!

请您先完成教学实验,才能开启自由实验!

Experiment Manual

The following content is displayed on the same screen for your experiment so that you can make any necessary reference in experiment. Start your experiment now!

  1. Log onto the SPP Management Interface(Duration: 0.5 min)
    Open the Firefox browser and click Sign in to enter the SPP Management Interface.
  2. Set up the SLA backup policy for databases(Duration: 3 min)
    Click Application > SQL > Backup in turn in the left-hand navigation bar.
    Under Instances, click WIN-NTASDQ855H1.
    Check the database to be backed up: sppdb.
    Click Select SLA Policy.
    Check 4.SQL under the SLA Policy.
    Click Save to complete the setting step.
  3. Execute the database backup task(Duration: 3 min)
    Under the SLA Policy Status, find the policy 4.SQL.
    Click Actions at the far right, and select Start to execute the backup task immediately.
  4. Monitor the database backup task(Duration: 10 min)
    Click to the left of the policy 4.SQLL, and you will see a backup task with a Status of RUNNING.
    Click on the left, and you will see the details of the task being executed.
    The backup task will be completed in 8min, and the Status will change to COMPLETED.
  5. Set up the database restore location(Duration: 5 min)
    Click Application > SQL > Restore in turn in the left-hand navigation bar.
    Under Instances, click WIN-NTASDQ855H1 >.
    Click to the right of sppdb >, and add this database to the restore list.
    Click Options at the lower right corner.
    Select the default Restore to original Instance for Destination.
    Type a name (e.g. sppdb1) under the New Database Name (please note that no duplication of name with the original database sppdb is allowed).
    Select Test for Restored Type.

    Click Save at the lower left corner.
  6. Execute the database restore task(Duration: 5 min)
    Click Restore on the upper right corner to execute the database restore task.
    You can view the restore progress in the Job Session(s).
    The restore task will be completed in about 3min when 100% is displayed in the Progress column.
  7. View the restored database(Duration: 2 min)
    Minimize the Firefox browser, and double click (icon name: 03_win2k12_SQL) on the desktop to log onto this VM.
    Wait for about 1.5min until SQL starts, and then Click Connect.

    Unfold Databases on the left, and you will see the restored database sppdb1.

请扫描下方二维码


沪ICP备18004249号-3