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 |
|
nageswar
Starting Member
5 Posts |
 Posted - 2008-08-04 : 07:36:23
|
| 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...From,Nsgeswar.v---Thanks, Nageswar.V |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-04 : 07:44:04
|
| can you explain your situation more? they've deleted the actual .ldf file? (if so, how?) or they truncated it?what recovery do you want? restore the current db without the log file? or you mean you want the logfile data back? (that's not gonna happen by the way)Em |
 |
|
|
nageswar
Starting Member
5 Posts |
Posted - 2008-08-04 : 07:56:22
|
quote:
Originally posted by elancaster
can you explain your situation more? they've deleted the actual .ldf file? (if so, how?) or they truncated it?what recovery do you want? restore the current db without the log file? or you mean you want the logfile data back? (that's not gonna happen by the way)Em
HI, Thank you for replay, actually my friend deleted .ldf file , when we are create database that time create one file na .ldf file that file space is more than 100 Gb, so he was deleted , so i want to how to use that database again...From Nageswar.---Thanks, Nageswar.V |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-04 : 08:15:47
|
| still not entirely clear on what's happened or what you want from your description, but you can attach a database (.mdf) without the .ldf and it will just create a new one.Em |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-04 : 09:34:43
|
| Was SQL Server stopped while deleting Log file? Try to attach withsp_attach_single_db? |
|
|
|
|
|
|
|
|
Deleted Transaction Log..