Overview

Introduction

The High Availability and Disaster Recovery Strategy module provides you with the instructions and devices to develop your hands on skills in the following topics.

  • Backing up and restoration of an SSAS database
  • Backing up and restoration of an SSRS database
  • Backing up and restoration of an SSIS catalog

Exercise 1 - Backing up and Restoration of an SSAS Database

SQL Server enables you to back up and restore your databases, thus providing a way to recover data. In this exercise, you will learn how to backup and restore a SSAS database. Prior to the task of performing a backup and restore, you will first create and deploy an SSAS cube.

Exercise 2 - Backing up and Restoration of SSRS Database

A SQL Server Reporting Services (SSRS) database stores metadata related to SSRS datasources, reports, and datasets and object definitions. An SSRS installation installs a report server database that uses the SQL Server Database Engine to store contents. The installation creates two databases namely ReportServer and ReportServertempdb respectively. The ReportServer database stores persistent data storage, whereas, the ReportServertempdb stores temporary data. The main database administration tasks in Reporting Services are to back up and restore the report server databases. In this exercise, you will learn how to back and restore the ReportServer database that is running in a local Database Engine instance.

Exercise 3 - Backing up and Restoration of SSIS Database

The SQL Server Integration Services (SSIS) database is hosted by the Integration Services server. The Integration Services server is an instance of the SQL Server Database Engine. The SSIS database stores SSIS packages, permissions, projects, operational history, and parameters. Like other databases, you can also backup and restore the SSIS database to avoid any data loss. In this exercise, you will perform the task of backing up and restoring the SSIS database. Prior to this task, you will create an SSIS catalog, which is the key point for managing Integration Services server operations and is represented by the SSIS database.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.