Problem: Whenever the database is corrupted due to any problem like hardware issue, or due to some heavy insertion of data in to the database which actually made some data corruption... and database went to suspect mode... of course we can make to emergency and copy the objects to another database in order to bring the data back in many cases. Think about the situation of data corruption and the databases are offline and no0t able to bring back ?
Solution: Without backup , we cannot bring the data back.. 1. First Check whether you have backup or not. 2. let say we have full backup and 4 sequesnce of log bakcup 3. Before restoring the database from the bakcup , we should make sure that the database is in full recovery mode (used for point in time recovery) 4. you should take tail backup for the corrupted database- which is used to take the data which are currently presents in the ldf file.. 5. now we can start to restore the latest full backup with no recovery option 6. restore all the log backup by sequence with no recovery option 7. finally tail log backup have to restore -- this is last step which will bring all the data till the time the database corrupted. 8. Now we have uptodate data back.... :)
"due to some heavy insertion of data in to the database which actually made some data corruption"
Something wrong with your system if that happens ... unless you were meaning that you were doing bulk import without transaction and it failed half way through, and to repeat the bulk import you want to restore-and-repeat
Agreed with Gail ...I have never found data corruption due to heavy or rapid data insert it might cause system goes busy but i don't think database would be corrupt..If i am not wrong.
Point in time recovery
Posted - 06/20/2010 : 06:13:40
