Topic: Database Recovery
Not finding your answer? Try searching the web for Database Recovery
Answers to Common Questions
how to recovery database of hdd?
Try GetDataBack from: http://www.runtime.org/gdb.htm The free version will at least tell you what you can recover. Read More »
Source: http://www.experts-exchange.com/Q_21846288.htm
How do you monitor database health after a disaster recovery?
Database health checkups assure business continuity irrespective of any major changes by providing data availability and complete recoverability. Our DBA team uses automated assessments as frequently as desired. This helps to mitigate risks... Read More »
Source: http://wiki.answers.com/Q/How_do_you_monitor_database_health_afte...
What is database recovery ?
In the field of information technology, data loss refers to the unforseen loss of data or information. An occurrence of data loss can be called a Data Loss Event and there are several possible root causes. Data loss must be distinguished fr... Read More »
Source: http://answers.yahoo.com/question/index?qid=20061205064102AA7M0B2
More Common Questions
Answers to Other Common Questions
Recovery is when transactions are being rolled forward/back until the database is in a consistent state. Unless you have a backup you want to use, the only safe thing to do really is wait it out. A database going into recovery spontaneousl...
Read More »
Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Serv...
if you are using RMAN http://arjudba.blogspot.com/2008/04/use-rman-to-validate-before-and-after.html
Read More »
Source: http://www.experts-exchange.com/Q_24830739.htm
In deffered database the transaction is committed after the transaction is completed i.e(the transaction has completed its partially committed state) where as for immediate database the transaction is commited when tha transaction is in the...
Read More »
Source: http://wiki.answers.com/Q/What_are_the_salient_features_of_deferr...
You should only see the Recovery entry at SQL Service start-up (not during normal SQL Server operation), and will only see it for databases that had uncommitted transactions at the time the Service was stopped. Could it be that the database...
Read More »
Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Serv...
The easy way is to use SSMS. Right-click on the database, choose Properties. Go to the Options page and it's one of the options there. But... before you press 'Ok', hit the "Script" button at the top, so that you get the script for making t...
Read More »
Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Serv...
Buying any of this stuff is going to be somewhat expensive, and the process is very time consuming and requires zero mistakes to be successful. Drives fail for a million reasons. In the case of a media failure, the problem is typically cau...
Read More »
Source: http://www.experts-exchange.com/Q_21619570.htm
Logs and Dumps for Recovery: ===================== Dumps are coming from either logical/physical backup. Once you are have the backup of what you want i.e. table(s)/schema(s)/tablespace(s)/database level backup, you are somewhat safe. If yo...
Read More »
Source: http://www.experts-exchange.com/Q_25345648.htm
