December 17, 2003 at 8:42 pm
Dear friends,
I have a problem. I have transaction log backups taken every 2 hours, differential bkps every day night and full bkp once in a month(full recovery model). Transaction log backup is take at 10 am. Due to a wrong update done by a user at 10.30 I was asked to do a point in time restore to that point.
but the current time is 11.15. If I do a point in time restore to 10.30 am , how can I apply other transactions(which are not related to the problem one) which have occured till 11.15 am. how to recover that from the current log and apply it selectively. Matter very urgent. Kindly help
also kindly tell me if i restore filegroups(group 1 and group 2) which all transaction logs i should restore and the sequence. I am confused on that
with regards
Anil
December 18, 2003 at 6:15 am
First back up the tran log. Restore the most recent full backup with no recovery. Then restore the most recent differential backup with no recovery. Restore the latest tran log that was made prior to the differential backup with no recovery. Retore subsequent tran log backups including the 10am backup with no recovery. Restore the tran log backup you just made with point in time recovery.
--Jonathan
--Jonathan
December 18, 2003 at 7:24 am
When you do a point in time restore the database will be restored to that point in time. Now if you can identify the corrupted transaction and the data it INSERTED, DELETED, and UPDATED then you might be able to programatically backout just the corrupted transactions. You might consider backup up your current database that is corrupted. Then create a new database using the corrupted database's backups a point in time prior to the corruption. Then write that program to read the record for the new database and then update the corrupted database. Good luck. Just to let you know I always tell my customers if you want me to restore the database to a point in time, then all the data added after that point in time will be lost.
Gregory A. Larsen, DBA
Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp
Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 18, 2003 at 8:14 am
I know many of the great guys here contributed to the BestOfSqlServer.com 2002.
It may be a good idea to give some details about the book.
--A picture of the back cover
--the hot topics covered
or some kind of specifics about the book
Mike
December 18, 2003 at 9:29 am
More information about the book can be found here:
http://www.sqlservercentral.com/bestof/
Gregory A. Larsen, DBA
Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp
Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply