mistakenly deleted database but recovery takes time while the company is still running -


my friend mistakenly added update clause , changed company's database. thing backup everyday @ time. trying recover. recovery takes several hours, , company still producing products , running 24/7 has run production table/database (probably understanding?) current use during recovery time. problem is, during recovery hours new data still being produced. after recovery finishes, how deal these new data during these several hours?

i not know if such kind of questions can asked here. story happens friend in non english country, country without site him ask here. worried.

do guys have basic thought or idea it? wonder normal solution since imagine kind of things might happen in modern life sometimes.

update: told me company produces important things , shutting down several hours cause huge loss

even though questions seems broad still try answer it.

  1. determine how many tables affected

  2. for each table determine records changed , columns changed

  3. determine if current transactions, stored procedures , functions or other software has changed of records/rows step 2. , how being run (they might changing records read this)

  4. determine if operations step 3 inconsisten because of changes made incorret update. (money or other calculation comes mind)

after should able determine if best keep running database altered incorrectly , allow user , other sofware continue updating records after manually altered or if best let people know urgent maintenance needed, agree them on maintenance window , fix problem before updated records , information propagated , used take importan decisions

my personal advice. determine plan recover affected data point in time records made sense , try re-run transactions happend after exact moment. try determine how time take , agree on urgent maintenance window users , other software might acceess database.

a database set maintenance mode, no users or other software can acccess it, runs faster , allows recover or undo damage faster if try keep accesable user , fix damaged records.

other approach be..(even if not sound professional)...let time pass , if no user complains updated records old or not accesed or important user, case , is best accept , fix problem "hoping best"

i have "reposted" question on serverfault

https://serverfault.com/questions/749596/mistakenly-deleted-database-but-recovery-takes-time-while-the-company-is-still-r


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more