September 18, 2007 at 12:26 pm
Hi Everybody,
Today i had done small mistake
Yesterday I had Taken Full backup at 10:00 AM.
Today Morning I had Modify 3 tables
but after 1:30 PM My developers mailed me U have done 3 table modification wrong can u please restore same data but this database is on line Database
I can take TlogBackup Online users are disturbing
Can u any body plz give suggestion How can I restore My Database
with out using Restore a Transation log backup
There is any another options is there to Restore that database plz give some suggestions
Thx
September 18, 2007 at 12:37 pm
You could restore the database to another location or another name then drop and import the restored tables.
September 18, 2007 at 12:41 pm
Hi,
you can restore the full backup only, and ignore the log backup. The disadvantage is that you will not have the data modifications since the full backup. If you would like to do a selective restore, i.e. you want to restore the database from the full backup, and then apply only parts of the changes since that time, you may want to look at some third party tools. Red Gate has Log Rescue for SQL Server 2000 (this is a free product), or you can look at Apex and Lumigent.
Regards,
Andras
September 18, 2007 at 1:07 pm
Hi Andras
See my situvasaction is some transaction are going on but both transaction are wrong
now i am restore the database as same situvasation how can i done
I restore the database The database on line users are distrubing can u plz cheack it ang give the exact solution
Restoring Tlog logbackup is not good i am thinking
On line user are distring
can u any body plz help me
Thx
September 18, 2007 at 3:09 pm
I would follw JDixon's advice. Restore your full backup to another database. DO NOT restore it over your production DB. Then grab the rows that correspond to the 3 modfications you made and manually update your production DB to how it was before your updates.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply