2012年3月11日星期日

Disaster Recovery Plan example

Hi,

Can any one please share the sample disaster recovery plan. I dont know what I have to include in it and how to prepare it. Your help will be highly appreciated. Thanks in advance...

I dont have a sample. but i can give u some ideas to get u started.
basically a plan would include this headings.

intro - what process are u using for ur DR. is it replication, mirror, backup/restore . state acceptable recovery dowtime.

Procedure:
if its backup and restore then where do u backup. location. how backup is set up .

indentifiable Risks:
hardware failure.
power failure.
flooding.

Resoluton:
implent recovery and get replacement.

Recovery:
what steps to take to restore db and logs. what access to check. if u will restore to a temp server then the client machines will have to change the .ini file to point the applications to the new temp server.|||http://www.sql-server-performance.com/disaster_recover_examples.asp

http://www.e-janco.com/drp.htm?gclid=CP3Hmtzk74cCFRNlYQod5wY-hA

http://databases.about.com/od/sqlserver/a/disaster.htm|||Thank you very much DaPosh for leading me in the right direction...

没有评论:

发表评论