Recovery & Backup

SQL Server 2014    |    Expert
  • 9 videos | 42m 28s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 18 users Rating 4.6 of 18 users (18)
BI administrators need to ensure that stored data is valid and available to the users. Discover how to design and implement strategies for data backup, recovery, and logging in a BI solution.

WHAT YOU WILL LEARN

  • Design a recovery strategy for ssas and ssrs databases
    Perform a backup of ssas databases
    Perform a backup of the ssrs databases
    Perform a restore of a ssas database
    Perform a restore of the ssrs databases
  • Configure logging within an etl package, container, and task to capture run-time information
    Enable logging for package execution on the ssis server
    View log entries that are written after a package is run in the log events window
    View package execution reports provided by the ssis catalog

IN THIS COURSE

  • 5m 5s
    In this video, find out how to design a recovery strategy for SSAS and SSRS databases. FREE ACCESS
  • 4m 53s
    In this video, learn how to back up SSAS databases. FREE ACCESS
  • Locked
    3.  Backing up SSRS Databases
    3m 56s
    In this video, you will learn how to perform a backup of the SSRS databases. FREE ACCESS
  • Locked
    4.  Restoring SSAS Databases
    4m 28s
    In this video, you will restore a SSAS database. FREE ACCESS
  • Locked
    5.  Restoring SSRS Databases
    4m 39s
    During this video, you will learn how to restore the SSRS databases. FREE ACCESS
  • Locked
    6.  Configuring Logging in an ETL Process
    5m 47s
    In this video, you will learn how to configure logging within an ETL package, container, and task to capture run-time information. FREE ACCESS
  • Locked
    7.  Enabling Logging for Package Execution in SSIS
    3m 36s
    During this video, you will learn how to enable logging for package execution on the SSIS server. FREE ACCESS
  • Locked
    8.  Viewing Log Entries in the Log Events Windows
    4m 28s
    In this video, you will view log entries that are written after a package is run in the Log Events Window. FREE ACCESS
  • Locked
    9.  Viewing Package Execution Reports
    5m 37s
    Learn how to view package execution reports provided by SSIS catalog. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Oracle Database Administration
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Journey Back-End Engineer

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course QlikView: Getting Started with QlikView for Data Visualization
Rating 3.7 of 89 users Rating 3.7 of 89 users (89)
Course Windows Server 2016 Identity: Active Directory Certificate Services
Rating 4.8 of 128 users Rating 4.8 of 128 users (128)
Course Data Security & Azure SQL Database Options
Rating 4.6 of 67 users Rating 4.6 of 67 users (67)