Recovery & Backup
SQL Server 2014
| Expert
- 9 Videos | 42m 28s
- Includes Assessment
- Earns a Badge
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 databasesperform a backup of SSAS databasesperform a backup of the SSRS databasesperform a restore of a SSAS databaseperform a restore of the SSRS databases
-
configure logging within an ETL package, container, and task to capture run-time informationenable logging for package execution on the SSIS serverview log entries that are written after a package is run in the Log Events Windowview package execution reports provided by the SSIS catalog
IN THIS COURSE
-
1.Designing a Recovery Strategy5m 5sUP NEXT
-
2.Backing up SSAS Databases4m 53s
-
3.Backing up SSRS Databases3m 56s
-
4.Restoring SSAS Databases4m 28s
-
5.Restoring SSRS Databases4m 39s
-
6.Configuring Logging in an ETL Process5m 47s
-
7.Enabling Logging for Package Execution in SSIS3m 36s
-
8.Viewing Log Entries in the Log Events Windows4m 28s
-
9.Viewing Package Execution Reports5m 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.