Windows Forum

Ask something
Discussion Locked

SQL Server Disaster Recovery Plans

0 helpful
3 replies

by diana.shanks

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone have any suggestions on Documents, Templates or any other material that could help me get started on setting up a Disaster Recovery Plan for my SQL Server Databases? I am a Jr. DBA and would really appreciate any feedback.
Thanks.

3 replies

by nnguyen7

Hello, I am in a similar situation and this is what how we implement desater recovery for standalone servers and sql cluster servers. On all servers a sql backup (dump) of all databases is scheduled nightly. After that we use ARCSERVE IT to perform a full system backup. We also use ARCSERVE IT Desater Recovery Plan. Depending on the problems, we could use SQL dump to restore the databases or use ARCSERVE IT to restore systems files and the databases. In a worse scenario, we use ARCSERVE IT Desaster Recovery Plan which require a boot disk and a good backup tape a restore the whole systems. As an alternative, we also use GHOST software to recover the complete system (faster) and then restore data from tape backup.

This discussion is closed to new replies.