Repair database without being attached (SQL 2005)

Hello experts,

Is it possible to try repair a database without being attached, giving the path to the files?
I'm trying to attach a database that i recover from a disk, and i'm not able to attach, gives me an error, saying i should do a db check.

Thx in advanced
LVL 1
justaphaseAsked:
Who is Participating?
 
didnthaveanameConnect With a Mentor Commented:
Not within SQL Server itself.  I have seen some 3rd party utilities that can supposedly recover data from the database files, but I've never had to use one - backup/restore strategies are crucial.

Edit: meant to include a link to one that I have no clue as to the quality aside from some reviews I saw: http://www.nucleustechnologies.com/sql-recovery.html
0
 
didnthaveanameCommented:
Nice info! Helpful for me too!
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
EvilPostItCommented:
No probs, let me know if you need any further info.
0
 
justaphaseAuthor Commented:
I knew there was a way to repair a MDF file outside SQL Engine. I already saw this once but forgot!
Thx :)

I'll try and come back to say how it went.
0
 
justaphaseAuthor Commented:
It's not easy.. the MDF file is really bad..
I was able to attach :)
Then went to recovery mode :|
Then went to recovery pending :(

The software to recover the data is to expensive... what to do now... :(
0
 
EvilPostItCommented:
Do a dbcc checkdb against it to see whats wrong with it. Then report back here with the output if you like.
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.