Post reply

How to Create a Disaster Recovery Plan

  • October 27, 2004 at 1:27 am

    #108741

    Dear All DBA Gurus

    I am new to this Profile, I am working as a Support Eng for Database. Recently there was a power failure i dont know much about Disaster Recovery, Can anyone help me out how to create a Disaster Recovery Plan.

    Any help is greatly appriciated.

     

    Thanks & Regards
    Dharmendra S Mudaliar
    ( OEM India RSA )
    Hello - +91 40 66934555 x 34555
    Mobile - 9885408049 | IM - v-dharmu@microsoft.com

  • October 28, 2004 at 1:11 am

    #528246

    Hi,

    DR is a big subject and a plan can become complicated if you are not careful.

    There are many resources on the web on producing DR plans, but if you are new this can be daunting.

    A good start, for your database environment, would be to go through some simple steps of information gathering.

    A few could be:

    • Can you categorize the degree of disaster ( Hard disk failure or total server crash) and who is affected by each type of disaster
    • What are your most important databases (are there any test environments)
    • What processes must run to keep the system active (Replication, jobs,DTS)
    • Are the important processes documented for 'non-IT people'
    • Are there checklists in place to ensure the system is running.

    The list can go on.

    You need to gather as much information as you can about hardware, software, business impact and communication procedures (who does what in a disaster).

    This is by no means the answer but it should start you thinking about what needs to be done.

    Hope this helped.

    Graeme

  • October 28, 2004 at 1:24 am

    #528250

    Dear Graeme

    Thanx for your kind support Sir. It was a Server Crash and the server is not able to start i dont understand what to do with it. I am really afraid. Pls help me out. I am really new to this environment.

    Thanx Graeme

    Thanks & Regards
    Dharmendra S Mudaliar
    ( OEM India RSA )
    Hello - +91 40 66934555 x 34555
    Mobile - 9885408049 | IM - v-dharmu@microsoft.com

  • October 28, 2004 at 8:28 am

    #528305

    I assume your asking how to recover the box, not how to create a plan? Can you tell what has failed? Do you get to the bios when it boots? - If no you have a motherboard, RAM, video card or other hardware failure.

     Can you get into bios to see if the disks are recognized? If not, you may have a disk controller failure, or bad disks.

    If it gets past bios, will it start Windows? If not can you get to the recovery console (windows 2000 and higher only)?

    Give me some more info on the box and I'll see if I can give you any more suggestions.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply