Overview
Disaster Recovery falls into two categories; planning and recovery. Planning
refers to the process of having a well established, documented & thoroughly
tested process to address any kind of disaster (be it a major data-loss due to
a human-error or natural disaster like earthquake), where as recovery refers to
the process of recovering from a disaster and minimizing the amount of downtime
and data loss.
Before a plan is created, it is essential to consider the various types of
disasters and the potential risks using the risk management practices. In a SQL
Server environment various risks are consistent and a standardized approach can
be implemented and documented to handle these situations. In addition to these
standard items, customization does need to occur to ensure the plan matches
your environment and business requirements.
Once the Disaster Recovery plan is established, it must be maintained, tested
and audited to ensure that it remains appropriate for the ever changing
organization. If the plan is not kept current, it could prove costly on during
the most critical time, a recovery from a disaster.
The process of creating and maintaining a disaster recovery process can be time
consuming and this is where SQLSquare can assist in implementing and
maintaining the appropriate process for your environment. A standardized
approach can be implemented for most of the common known failures.
Why do you need it?
Can you run business with out Data after a disaster that affects your database
server? About 70% of the businesses go out of business in one year after a
major data-loss, say one recent survey.
SQLSquare Services & Approach
SQLSquare can put together a process that works for your environment using the
following techniques:
-
Document existing configurations in order to determine the necessary SQL Server
preventive measures in case of a disaster.
-
Identify areas of vulnerability for your existing SQL Server environment and
determine the most appropriate strategy to correct these areas.
-
Determine the necessary schedule to collect environmental information in order
to most appropriately recover from a disaster.
-
Determine a cost effective solution to recover in the needed amount of time
based on business requirements
-
Provide solutions to recover from hardware, operating system, SQL Server and
data failures in order to restore your business environment.
-
Assess the current backup procedure and align them to fit into the disaster
recovery plan
-
Assess risks and weaknesses
-
Maintain documentation
-
Introduction of tools (documentation, clustering, auditing, etc...)
-
Create a schedule for testing and the necessary tests to perform to ensure
process still works
-
Prioritized list of servers, databases and applications for recovery order
-
Periodical testing of the disaster recovery plan and strategy including
drill-through
-
Standardized documentation procedures
-
Centralized documentation
-
Methodology to keep documentation current
Contact SQLSquare today!
|
