October 19, 2006 at 8:41 am
Hi,
Using SQL SERVER 2000 on Small Business Server 2003.
The trasanction Data been written and the Trasanction ID been generated by SQL Server but in almost at the same( may be 1-30 minutes) time the SQL server deleted the same record (not sure how it happened)
We have printed copies of the Transactions that been entered.
It means the transaction details been definelty entered into the database but some how the same transaction been deleted.
We have the regular complete backups but not the trasanction backups.
Now, need to check for the last one year, any data been deleted from the database by HW/OS/SQL(Hardware/Operating System).
One of the possibilities that considering is by rebuilding the database by using .ldf(transaction log) file and compare with the present database.
1. The question is whether can we rebuild a database somehow with .ldf file only, if we can, can some one suggest how to rebuild the database.
2. Or is there any way to find out the Deleted Entries in the Database. (Note: We don't have Transaction Log Backups)
Or could some one have better possibilities.
Thanks in advance.
Vij
October 19, 2006 at 9:10 am
Is the database using the Simple recovery model? If so, there's no way you can retrieve transactions that occurred over the past year because everytime a checkpoint occurred, the entries would be cleared. Nor can you recover the database from only the t-log file.
You could restore your full backups with new names and compare them with the current database. Tools like ApexSQL Diff would make that a lot easier.
I can't think of any other suggestions.
Greg
Greg
October 19, 2006 at 9:22 am
Hi Greg,
Thankyou.
The database is in Full Recovery Model. Does this any kind of help.
Vij
October 19, 2006 at 9:55 am
Yes. Backup the log right now. Now, you can restore the database from the last full backup and the log backup to a point in time.
You'll still be stuck with finding the delete transactions. Lumigent Log Explorer is a great tool for finding particular transactions and reversing them. I highly recommend it for situations like this.
Greg
Greg
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply