در این آموزش تصویری با رفع خطاها و خرابی های بحرانی SQL Server آشنا می شوید.

این دوره آموزشی محصول موسسه Udemy است.

سرفصل های این دوره:

  • آشنایی با دوره
  • ابزارهای مورد نیاز
  • پارامترهای راه اندازی SQL Server
  • شروع نامگذاری و قرار دادن آن در User Mode
  • عیب یابی مشکلات راه اندازی با اکانت های قفل شده
  • عیب یابی مشکلات راه اندازی با پورت های در حال استفاده
  • راه اندازی با پاک کردن خطاهای Log
  • توضیحات ErrorLog
  • عیب یابی ریکاوری SQL Server
  • بازگرداندن منابع DB از نمونه های دیگر
  • بازگرداندن پایگاه داده
  • بازیابی رمز عبور
  • تعمیر Tempdb

عنوان دوره: Udemy SQL Server Crashes and Critical Failures

سطح: متوسط

نویسنده: Mike West

مدت دوره: 1 ساعت


Udemy SQL Server Crashes and Critical Failures
A Step By Step Approach To Recovering The Most Critical SQL Server Databases

Mike West
1 hour
Intermediate Level

Software crashes. WE can't stop that. What WE can do is prepare ourselves through education and practice to be able to act quickly and resolve these critical issues.

In the early days of SQL Server many support calls were server down issues that ended up being bugs in SQL Server. While this still happens, today many of those calls aren't the fault of SQL Server.

For example. On Microsoft's case history of database corruption 99% of ALL database corruption can be traced back to the IO subsystem.

Either way, when SQL Server crashes it can be a traumatic experience for a DBA. If a production box crashes during core hours WE need to know what steps to take to resolve the problem as quickly and as cleanly as possible.

This course will take US beyond where to look. WE will cover RECOVERY INTERNALS and the fundamentals of how to analyze, diagnose and resolve critical errors.

WE will cover the SQL Server Error Logs in great detail. One of the first places as SQL Server DBAs WE look to diagnose critical failures is the SQL Server Error logs.

WE will cover server startup failures and analyze SQL Server stack dumps. Additionally, we will analyze several commonly occurring exception signatures.

WE will create a troubleshooting task list as use it as a template for resolving these crashes and critical errors.

While this course has no prerequisites a strong background in SQL Server is highly recommended.

What are the requirements?
There are no prerequisites for this course but a solid foundation in SQL Server would be helpful.
All of the materials will be free or included in the course. There will be no outside purchases necessary to take this course.
Any recent version of SQL Server will do but I'd recommend SQL Server 2014.
What am I going to get from this course?
You will be comfortable with reading the SQL Server error log in great detail
By the end of this course you will be able to diagnose and resolve critical SQL Server engine errors.
You will be able to read the basics of SQL Server stack dumps.
What is the target audience?
SQL Server DBAs wanting to expand their knowledge of how and why SQL Server crahses
This is not an entry level SQL Server course. I would not recommend this course for beginners.
SQL Server DBAs looking to understand exception signatures and other vernacular associated with critical failures in SQL Server

Section 1: Introduction
Lecture 1
Course Introduction
Lecture 2
Instructor Introduction
Lecture 0
Download Course Content Here
Lecture 3
Tools We Need For The Course
Lecture 4
The Three Categories of Critical Failures
Lecture 5
Section 2: SQL Server Startup Parameters
Lecture 6
The Startup Parameters SQL Server Needs
Lecture 7
Starting A Named Instance and Putting That Instance in Single User Mode
Lecture 8
Troubleshooting The Failed Startup With Account Locked Out
Lecture 9
Troubleshooting Failed Startup When Port Already In Use
Lecture 10
Section 2 Summary
Quiz 1
Section 2 Quiz
15 questions
Section 3: Error Log Dissection
Lecture 11
Starting With A Clean Error Log
Lecture 12
What's in The ErrorLog - Part 1
Lecture 13
What's In The ErrorLog - Part 2
Lecture 14
What's In The ErrorLog - Part 3
Lecture 15
What's In The ErrorLog - Part 4
Lecture 16
Quiz 0
Section 3 Quiz.
10 questions
Section 4: SQL Server Recovery Troubleshooting
Lecture 17
Restoring The Resource DB From Another Instance
Lecture 18
Restoring The Master Database When Instance is Online
Lecture 19
Recover Corrupt Model Database From Another Instance
Lecture 20
Recovering A Lost SA Password
Lecture 21
Repairing Tempdb Corruption
Lecture 22
Rebuilding the Master Database
Lecture 23
Quiz 2
10 questions
Section 5: Conclusion
Lecture 24
Conclusion and Thank You