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 |
|
paramesh
Starting Member
2 Posts |
 Posted - 2008-11-11 : 03:01:20
|
| Below the senario.Started a production server at 9:00 AM and transaction also started.Backup type is Full Recovery Model..Mdf file is in D Drive and .Ldf file is in C Drive.Unfortunately D drive got crashed and not able to get .mdf file which is in D Drive, we have only .ldf file we have to recover the data.If any one know the solution pls update.Thanks in advance. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-11 : 04:28:19
|
| The mdf and ldf files are the actual data files. Do you still have access to the Backup files i.e. the *.BAK and *.TRN files? If you don't have access to the drive they are on, is the drive itself backed-up e.g. to tape? |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-11 : 04:31:10
|
| as mdf being the master file, holding all the data it is not possible to recover ONLY from ldf. |
|
|
|
paramesh
Starting Member
2 Posts |
Posted - 2008-11-11 : 06:29:37
|
quote:
Originally posted by darkdusky
The mdf and ldf files are the actual data files. Do you still have access to the Backup files i.e. the *.BAK and *.TRN files? If you don't have access to the drive they are on, is the drive itself backed-up e.g. to tape?
by using *.BAK & *.TRN how we can retrive the data with .ldf file. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-11-11 : 12:07:25
|
| Restore the database from the backup file (*.bak and *.trn)The procedures for doing this are well documented in SQL Server 2005 Book Online, so you should read that.CODO ERGO SUM |
|
|
|
|
|
|
Recover the database with out .mdf --- Pls help