• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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.
0
umaxim
Asked:
umaxim
3 Solutions
 
Brian CroweCommented:
you can attach the mdf and ldf files.

http://technet.microsoft.com/en-us/library/ms190209.aspx
0
 
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now