September 15, 2009 at 2:38 am
How can we attach the database? I have only MDF file There is an any way to attach or Another way to recovery that mdf..?
September 15, 2009 at 2:43 am
Just attach the mdf you have and then in the bottom box (that displays the two files), highlight the log and click remove.
When you click OK, the mdf/database will be re-attached and sql will create a new log.
Adam Zacks-------------------------------------------Be Nice, Or Leave
September 15, 2009 at 3:26 am
Thank you so much,working fine........
September 15, 2009 at 3:28 am
But you might have data loss as log file is missing.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 15, 2009 at 3:45 am
free_mascot (9/15/2009)
But you might have data loss as log file is missing.
oh mascot :-P.
if the ldf was missing, how can you lose what you never had. only uncommited perhaps but without knowing about the ldf, you cannot make that assumption.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 16, 2009 at 12:51 am
That was the reason I have used "might". 😉
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 16, 2009 at 1:09 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply