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...
没有评论:
发表评论