<div>
<div class="content wysiwyg-content">
We currently have 1 SQL 2008 Management Studio. &nbsp;Let me first state I'm not SQL trained other than minimum knowledge. &nbsp;What I'm looking for is advice on what to do to prepare for disaster. &nbsp;If our SQL server crashes, how do I ensure that I have a plan in place to get us back up and running on another server ASAP. &nbsp;I do realize that all the programs using SQL will have to be redirected to the new server. &nbsp;I just want help creating a plan to insure we are as prepared as possible recover what was on the server.
</div>
</div>


We currently have 1 SQL 2008 Management Studio.  Let me first state I'm not SQL trained other than minimum knowledge.  What I'm looking for is advice on what to do to prepare for disaster.  If our SQL server crashes, how do I ensure that I have a plan in place to get us back up and running on another server ASAP.  I do realize that all the programs using SQL will have to be redirected to the new server.  I just want help creating a plan to insure we are as prepared as possible recover what was on the server.

Need advice on create a DR plan for SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.