November 6, 2008 at 9:57 pm
There are many different ways including 3rd party tools to recover lost data nowadays. I am trying to collect all the possible solutions for these scenarios:
A.Table has been dropped
B.Table has been truncated
C.Some or all the records from a table being deleted
Any one would like to share?
November 6, 2008 at 11:33 pm
Vivien Xing (11/6/2008)
There are many different ways including 3rd party tools to recover lost data nowadays. I am trying to collect all the possible solutions for these scenarios:A.Table has been dropped
B.Table has been truncated
C.Some or all the records from a table being deleted
Any one would like to share?
i dont understand why to use third party tools, if you have
1. dB mirroring
2. jobs,
3. backups
4. logs
and many more....
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 7, 2008 at 4:52 am
One Answer BACKUP
If there is a good fail over plan then you will have answer for all your questions
Hope this helps 🙂
November 7, 2008 at 5:06 am
krayknot (11/6/2008)
Vivien Xing (11/6/2008)
There are many different ways including 3rd party tools to recover lost data nowadays. I am trying to collect all the possible solutions for these scenarios:A.Table has been dropped
B.Table has been truncated
C.Some or all the records from a table being deleted
Any one would like to share?
i dont understand why to use third party tools, if you have
1. dB mirroring
and many more....
1. DB mirroring is not useful for data recovery as the mirror is synched with the principal database. It is used for high availability.
There are a couple of really useful log readers available that can help to recover data and roll back changes, though this depends on the budget you have available to you.
November 7, 2008 at 6:17 am
Hi Vivien,
The best way is to restore from a backup to a certain point in time (in case of full recovery mode).
This keeps your data consistent across your tables.
In case of loss of a some records in a table and you prefer not to restore the full database to that point in time,
you can also follow this approach : restore the database to another name.
After that you can copy the missing rows back from the restored db into the original db.
Be careful, make sure you maintain logical consistencies between tables (copying children from table A without parents from table B : check triggers and constraints ).
This approach is also useful in other scenario's (ex. wrong updates on some columns).
Grts,
Franky Leeuwerck
Franky L.
November 7, 2008 at 2:21 pm
Thank you for the response.
The case is, if the database is VLDB, only a very small table has been dropped or some/all of the records of that table have been deleted. Do you have to restore the whole database backup + transaction logs to retrieve the missing data?
I agree backup is always a must. But restoring database may be not efficient for quick recovery. That is why 3rd party tools are in the market.
November 7, 2008 at 5:01 pm
If you are running Enterprise Edition - you can use a database snapshot. As long as the snapshot is refreshed on a regular basis, you could then read the data from the snapshot and rebuild the data.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply