SQL Server Advance Corruption Recovery

The estimated reading time for this post is 1 minutes

This class will give you a wealth of practical corruption recovery techniques that you can put into production as soon as you return to work and we ensure you understand *why* and *how* a technique works rather than just what the technique is. This usually means we will explain how SQL Server works internally while discussing a specific topic. Our aim is that you can apply what we teach you to any situation and justify your solution to your peers, management, or clients (yes, we welcome SQL Server consultants in our classes).

This course will cover SQL Server 2005 through SQL Server 2014, and is essential for all SQL Server developers, DBAs, and architects. We will answer all your questions, to whatever depth you want to go.

Conducted For

 amway home page

Course Information

Title:             FS-4010A Microsoft SQL Server Advance Corruption Recovery

Duration:    2 Day

Time:            9:00 am – 05:00 pm

Intended for SQL Server administrators who are responsible for the integrity and availability of their database servers and installation.

Prerequisites

  • Experience with SQL Server.
  • Understanding of Database concept.
  • Experience with SQL Server administration.
  • Experience with Transact-SOL Programming.
  • Knowledge of SQL Server disaster recovery concept.

Course Outline

1- What is Disaster Recovery?

2- Database Backup Plan

3- Database Physical Design

4- Case Studies:

  •  I/O Logical Corruption Recovery
  • Suspected Database Corruption Recovery
  • Master Database Corruption Recovery
  • Object Recovery
  • Point in Time Recovery
  • File Corruption Recovery
  • Page Corruption Recovery
  • Log File Corruption Recovery
  • Online Database Recovery
  • Avoid Corruption by Mirroring
  • Avoid Corruption by Alert

 

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:
FacebookLinkedIn