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 |
|
PABluesMan
Starting Member
26 Posts |
 Posted - 2008-03-24 : 17:11:58
|
| Okay, another esoteric question for ya:My client recently (well, the middle of January, anyway) attempted to restore their year-end backup to do some reporting, only to find that the backup file was corrupted and unrestorable. They do have earlier monthly backups, but they do not keep transaction log backups past those monthly backups (i.e. transaction log backups for November are discarded once the monthly full backup has been completed).My question is this: is there any way to restore the month-end backup from January, then read the transaction log backups for the month of January to undo January's transactions?This is a highly business-critical issue; they are going to be in a lot of hot water with the SEC if they can't produce the financials stored in the DB.This is a SQL 2000 SP4 database.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-24 : 17:16:01
|
| You could try with a third party tool such as Lumigent's Log Explorer, Red Gate also has a tool.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Reversing transactions in the SQL transaction log