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!

How do I rebuild my sql database?

Status
Not open for further replies.

Chunks

ISP
Oct 15, 2004
1
GB
We had a drive corrupt on us the other day and we desperately need to get our sql database back up and running.
We managed to recover the mssql directory and contents but how do I now rebuild the database?
Do I need any other files?
Any help appreciated.
Thanks
 
You can attach the database, or you can restore from backup.

If you managed to to get the folder with that database files, than is easier to attach the database files.

In EM right-click on datasbases, select all tasks, and then Attach Database.
in the srceen that appeares select the location of the MDF file of that database that you want to attach...

Good luck


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top