Do you have any risk plan?

You have to admit that your applications or servers will be crashed. You have to be panic now. Because it's better to feel trouble than when you are in real trouble.

Most of company back up their database, their sources in case of any uninvited problem. That's great idea to back up isn't that?



What's next? Imagine that, your database is corrupted. Do you know what you should do? If you can you answer following questions, just wait trouble time comfortably, you don't need to be afraid of. You can feel a little bit fear, not to much.

1. How do you restore again?
2. How much time do you need to work the database again?
3. Who is/are responsible for restoring it?
4. Where is your database backup stored?
5. Is permission given to copy database backup from backup server to live database server?
6. Is there enough bandwidth between backup servers and live database servers?
7. Do you know username and password to access backup server?
   

Let's explain why answers of these questions are vital for your application.

1. Do you restore manually using management tool of your database or using command prompt in windows operating system or terminal in linux operating system? If you use command prompt or terminal, you have to be sure to remember code what your write. It's better to write down in any simple file like notepad. It's quick way to copy "restore statement" and paste it. Or you can create bat files for windows operation system.
2. While your database doesn't work, your users want to know when application will be used again. You should notify problem and time when database is restored and used again. Because your users will be angry. Also your managers. Ambiguity should be clarified.
3. It's simple answer. This person can be your system administrator or database administrator or both of them. Just assign any person to this vital task.
4. Person who is responsible this task have to know where back up files are stored.
5. Responsible person has to have enough permission to access backup files and copy this file to database server.
6. Bandwidth is most important factor to shorten restoring database time. It should be more bandwidth as far as possible.
7. Ok, you have enough permission to access database server and backup server. Do you remember username and password? Also you shouldn't remember you have to write down somewhere else to find it quickly.
   

Finally, all of this instructions should be written on your dashboard. It's easy accessible.