Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jtorral
Starting Member
2 Posts |
 Posted - 2010-03-16 : 22:59:21
|
| Is there anyway at all even by hacking to apply transaction logs to an existing database without having to do a full restore? In other words, user joe deleted 5 tables at 5:00 and I would like to roll back those transactions to 4:59 without restoring the database. Mainly because the database is so large and it would take so much time.Thanks |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2010-03-17 : 02:08:34
|
| First you can't restore transactional backup, without restoring FULL backup first (Restore with No recovery).Unfortunately, Sql Server still not provide any facility like ORACLE do (UNDO TABLE/DATABASE)So for POINT IN TIME recovery, restore your full backup (with No recovery) and then restore all the transactional backups and obviously last one with your given time. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-17 : 05:27:39
|
| There are Transaction Log readers which will enable you to extract transactions from the LOG. What you can then do with that depends on how much time you have, and how desperate you are!Normal approach is to restore to a new, temporary, database (to a point in time, 4:59 in your case), and then copy the tables / data / etc. from the Temporary database back to the Live databases |
|
|
|
|
|
|
Question about transaction log restores