Recovery & Backup

SQL Server 2014
  • 9 Videos | 45m 58s
  • Includes Assessment
  • Earns a Badge
Likes 8 Likes 8
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

  • Playable
    1. 
    Designing a Recovery Strategy
    5m 5s
    UP NEXT
  • Playable
    2. 
    Backing up SSAS Databases
    4m 53s
  • Locked
    3. 
    Backing up SSRS Databases
    3m 56s
  • Locked
    4. 
    Restoring SSAS Databases
    4m 28s
  • Locked
    5. 
    Restoring SSRS Databases
    4m 39s
  • Locked
    6. 
    Configuring Logging in an ETL Process
    5m 47s
  • Locked
    7. 
    Enabling Logging for Package Execution in SSIS
    3m 36s
  • Locked
    8. 
    Viewing Log Entries in the Log Events Windows
    4m 28s
  • Locked
    9. 
    Viewing Package Execution Reports
    5m 37s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 7 Likes 7  
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 78 Likes 78  
Likes 166 Likes 166  
Likes 26 Likes 26