I just did a major stupid thing-- I thought I could just delete a _log.ldf file if it was too big and so stopped SQL and deleted it-- Of course DB didn't work when I restarted SQL. I renamed the original .mdf file, detached the database, recreated the database and performed a restore, but the data is only as recent as the last backup. How can I restore the database with the old .mdf? is that possible? I tried first creating the database by using the attach method, but it wants an .ldf file. Help!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
can I restore a DB if I only have the mdf file? HELP!
- Thread starter plange
- Start date
- Thread starter
- #2
whew-- found this and it worked:
Reputation, job, self-respect saved. Woohoo! 
We've all made mistakes. Some are more easily correctable than others.
[COLOR=black #d0d0d0]When I walk, I sometimes bump into things. I am closing my eyes so that the room will be empty.[/color]
We've all made mistakes. Some are more easily correctable than others.
[COLOR=black #d0d0d0]When I walk, I sometimes bump into things. I am closing my eyes so that the room will be empty.[/color]
- Status
Similar threads
- Locked
- Question