Microsoft SQL

Hi i have a problem my database is corrupted and I do not make any backup.

My master file is corrupted.

But i have mdf and ldf files. Can I restore using this file.
LVL 1
umaximAsked:
Who is Participating?
 
ButlerTechnologyCommented:
Are you referring to the MDF and LDF of the Master database or a particular database? .  

If the corruption is your Master database then you won't be able to use the MDF/LDF as the files are corrupt.  You will need to reinstall SQL and then you will have the ability to attach your user databases.

Tom
0
 
Brian CroweDatabase AdministratorCommented:
you can attach the mdf and ldf files.

http://technet.microsoft.com/en-us/library/ms190209.aspx
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.