Top 5 SQL Server Disaster Recovery Plans For Your Database | Marco Pozzan

Overview SQL Server Disaster is a condition that causes data loss or any disturbance in SQL Server. There are various users, who face the similar problem but they do not know how to overcome from such problem. Therefore, in the below discussion there are some reasons for occurrence of disaster and different SQL Server disaster recovery plans. Why you should prepare the blueprint to Prevent SQL Server Disater? The disaster can be caused because of various reasons and some of them are mentioned below: Natural disaster Hardware failure Power failure Human error Due to issues related to SQL Server disaster that cannot be prevented, it is important to have a good disaster recovery plan that will be discussed in the following section. Best Disaster Recovery Plans for Database SQL Server DRP (disaster recovery plan) is a way to overcome from data loss after a disaster. Disaster recovery plan should be planned in way to avoid disastrous data loss and incidents. SQL […]

Источник: Top 5 SQL Server Disaster Recovery Plans For Your Database | Marco Pozzan


Когда сервер работает хорошо DBA должен думать о том, что он будет делать когда все сломается. Здесь кому как, лично мне очень не нравится технология кластеризации. Она сложна, капризна в использовании, бесполезна в случае сбоя СХД, не имеет защиты от катастроф (пожар в серверной, потоп в ЦОД). Лог шиппинг и репликация в этом плане выглядят куда интересней.

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *