Practical SQL Server High Availability and Disaster Recovery Год выпуска: 12/2015 Производитель: Pluralsight Сайт производителя: pluralsight.com/courses/sql-server-high-availability-disaster-recovery Автор: Russ Thomas Продолжительность: 4:40 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Congratulations, you’re the DBA. Along with all the rights, privileges, and prestige that comes with that. It also means you are responsible for not only the uptime and guaranteed availability of your database servers but also the ability for any of those servers to quickly recovery from any disaster imaginable. Supporting these two areas are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. This course will compare and contrast the many features, techniques, and concepts available in SQL Server that will meet your individual needs whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up. Поздравляем, ты в дБА. Наряду со всеми правами, привилегиями и престижем, что приходит с этим. Это также означает, что вы несете ответственность не только за время работы и гарантированная доступность ваших серверов баз данных, но и возможность для любой из этих серверов для быстрого восстановления от любой катастрофы можно себе представить. Поддерживая эти две области несомненно являются одними из основополагающих профессиональных навыков, необходимых для успешного старшего уровня дБА. Этот курс будет сравнить и сопоставить множество функций, методов и концепций, доступных в SQL Server, который будет отвечать вашим индивидуальным потребностям, работаете ли вы в многомиллионное предприятие или “туго с деньгами” старт-ап.
Содержание
Understanding High Availability vs. Disaster Recovery 11m 18s Introduction 2m 7s High Availability 2m 19s Disaster Recovery 3m 7s Policy 3m 44s Getting Familiar with the Transaction Log 19m 24s Introduction 1m 44s ACID Transactions 6m 0s SQL Server Data Storage 2m 50s Transaction Log Operation 3m 39s Transaction Log Storage 3m 14s Summary 1m 55s Taking Backups and Implementing Log Shipping 39m 18s Introduction 1m 23s Simple Recovery Model 3m 9s Full Recovery Model 2m 28s Point in Time Restores 5m 33s Bulk Logged Recovery 3m 3s Maintenance Plans 3m 8s Managing Backups 3m 15s Disaster Recovery from Backup 2m 23s Log Shipping Wizard 4m 18s Log Shipping by Script 3m 12s Custom Log Shipping Approach 2m 3s Custom Log Shipping Demo 3m 32s Summary 1m 45s Setting up Failover Clustering 59m 22s Intro 4m 35s Failover Cluster Concept 5m 37s Clustering Prerequisites 3m 31s More Clustering Prerequisites 3m 57s Building Cluster Environment 4m 25s Validating and Installing Failover Cluster 4m 40s Preparing SQL Server Nodes 3m 54s Completing SQL Server Cluster Installation 5m 28s Testing Manual and Induced Failover 3m 46s Active Passive vs. Active Active Concepts 3m 25s Troubleshooting 6m 1s Key Concepts and Summary 5m 1s Key Concepts and Additional Resources 4m 57s Supporting Legacy Mirrors 36m 58s Introduction 3m 24s Database Level Protection 1m 52s Synchronous vs. Asynchronous 3m 54s Creation of Endpoints 3m 43s Create Mirror 4m 22s Ansynchronous Mirror Failover 5m 48s Synchronous Mirror Failover 3m 57s Troubleshooting Mirrors 3m 45s Post Failover Problems 2m 52s Summary 3m 16s Installing and Supporting AlwaysOn Availability Groups 1h 4m Intro 3m 57s Terminology 4m 43s AlwaysOn AG Protection 3m 40s AbacosWidgets Business Case 2m 58s Installing and Configuring AlwaysOn 4m 42s Availability Group Setup, Joining Replicas, and Databases 6m 41s Failover Modes and Manual Failover 4m 32s Creating a Listener 3m 1s Automatic Failover and Read Only Secondary 4m 7s Adding Another Database 2m 14s Offloading Database Backups 3m 16s Configuring Quorum and Adding a Node 4m 17s Monitoring AlwaysOn AG 3m 10s Troubleshooting AlwaysOn AG 4m 3s Additional AlwaysOn AG Considerations 5m 36s AlwaysOn AG in SQL Server 2016 3m 19s Understanding Additional Approaches 34m 57s Intro 1m 50s Virtualization VMware 4m 12s Virtualization Hyper-V 5m 9s SQL Server in the Cloud 3m 5s IaaS and PaaS 3m 12s SQL Azure in Action 5m 36s Transactional Replication Publisher and Subscriber 4m 9s Transactional Replication Articles 3m 24s 3rd Party Options 4m 16s Bringing It All Together 14m 36s Recap 1m 46s Backups and Log Shipping 3m 18s Failover Clusters 3m 9s Always On Availability Groups 1m 49s Virtual Machines and the Cloud 2m 17s Final 2m 14s
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}