August 4, 2008 at 5:44 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 6:00 am
nageswar (8/4/2008)
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...
If you still have the mdf file you can attach only the mdf file. On 2000 use
sp_attach_single_file_db 'dbname', 'physical_name'
You can use the GUI to do this, in this case attach only the mdf file. A minimal ldf file will be generated for you, so you will be able to use the database assuming the database has been shut down cleanly. You may still loose some data, depending on how busy your database was.
Regards,
Andras
August 4, 2008 at 6:14 am
Just to merge the answers, this post is a duplicate of http://www.sqlservercentral.com/Forums/Topic546020-149-1.aspx
Regards,
Andras
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply