January 28, 2010 at 8:52 am
Hi all,
I have a database about 900Mb, that i deleted part of important data, after deleting, data file is about 600Mb and Log file is about 550Mb. i never didn't have a backup data and backup log for these database.
may i can to recovery the deleted data? and how to do it?
Thank you a lot.
January 28, 2010 at 8:57 am
If you have never, ever done a backup of that database (and if so why the hell not), then there is little or no chance that you will be able to get that data back. Regardless of recovery model, if there has never been a backup, the transaction log will be automatically marked as reusable every time a checkpoint runs and future log records will overwrite the old ones.
You can try buying a log reader tool. Apex sells one for around $1000, it might get you data back, if you use it fast enough. I wouldn't personally bet on it though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 15, 2010 at 8:48 am
I agree with Gail, I don't expect that you can do this. A backup is needed, and I'd caution you to note delete data if you don't have a backup.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply