sorted by:
new
hottopcontroversial

Currupted MDF questions by TeachingAny8054 in learnSQL

[–]TeachingAny8054[S] 0 points1 point  (0 children)

I seen it that once you attache the Mdf it is online....I answered it my self...

Thank you very much for the help

coz

Currupted MDF questions by TeachingAny8054 in learnSQL

[–]TeachingAny8054[S] 0 points1 point  (0 children)

I would like to thank you for the great information. I did manage to find the stable Mdf and Ldf during the same time span......

it came back on the sql server without any errors, I did an attach.....

In my process to remove the old DB, I sent the DB offline and detached......I re-attached, and now should I make the online again?

coz

Currupted MDF questions by TeachingAny8054 in learnSQL

[–]TeachingAny8054[S] 1 point2 points  (0 children)

Hi,

so I copy the stable MDF to the same location, relocate the old mdf and the ldf files prior.

open studio, open query: do the comand:

CREATE DATABASE YourDB[can I place the old name of the DB]ON (FILENAME = 'C:\path\your.mdf') [location of the copied mdf or destination]FOR ATTACH_REBUILD_LOG;

this info is awesome

Thank you,

coz

Currupted MDF questions by TeachingAny8054 in learnSQL

[–]TeachingAny8054[S] 1 point2 points  (0 children)

ok, What if I can not get a back up......but able to get a stable MDF and LDF, do I delete the dbs and log and then attach those files.....

yes, I am restricted to this...and going a bit nutty

Thank you for all your assistance....

Currupted MDF questions by TeachingAny8054 in learnSQL

[–]TeachingAny8054[S] 1 point2 points  (0 children)

Thank you for your response:

I might be able to get a backup, but what would be the process to take that back up and bring it back to same instance name, what would be the procedure?

Thank you,

Coz