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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Recovery using .ldf file if .mdf is not available.

Author  Topic 

brij.dba
Starting Member

2 Posts

Posted - 2010-06-11 : 09:06:49
Hi
I need to recover data from .LDF file whereas I have lost my .MDF file. My database was in Full Recovery Mode, I have full backup of a day back, but no transactional backup. Having full backup of Thursday, changes made in database on Friday. I dont have any backup of Friday, I need to recover till Friday. How can I overcome this problem, please give me some solutions.

SQL DBA

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-11 : 10:19:22
Asked and answered: http://www.sqlservercentral.com/Forums/Topic935967-384-1.aspx

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -