August 4, 2008 at 5:49 am
Hi All,
I am facing bib problem, one of my friend deleted LDF file for Live database, because it is almost 100Gb space, so how to recovery data from that databse ......please help me any way to recover data...
August 4, 2008 at 5:58 am
It would be interesting to know how he could delete a LDF file with the service running...
What's the database recovery model?
You could try to attach the database with a single file:
exec master.sys.sp_attach_single_file_db @dbname, @phisical_path
I would never want to be in your shoes, anyway...
Gianluca
-- Gianluca Sartori
August 4, 2008 at 6:05 am
If that does not work (presumably because the services were not closed correctly before the file was deleted), there is a recent article that has an approach to doing this:
http://www.sqlservercentral.com/articles/Disaster+Recovery/63311/[/url]
If you have to go this route, you will have some data loss. The amount will depend on the usage of the database between the most recent checkpoint and the time the database was taken offline.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply