Solved

Repair database without being attached (SQL 2005)

Posted on 2013-06-25
7
214 Views
Last Modified: 2013-06-30
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
0
Comment
Question by:justaphase
  • 3
  • 2
  • 2
7 Comments
 
LVL 8

Assisted Solution

by:didnthaveaname
didnthaveaname earned 100 total points
ID: 39275909
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
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 400 total points
ID: 39277505
0
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39277864
Nice info! Helpful for me too!
0
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
LVL 16

Expert Comment

by:EvilPostIt
ID: 39277873
No probs, let me know if you need any further info.
0
 
LVL 1

Author Comment

by:justaphase
ID: 39278458
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
 
LVL 1

Author Comment

by:justaphase
ID: 39278540
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
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 39279259
Do a dbcc checkdb against it to see whats wrong with it. Then report back here with the output if you like.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PK numbers not follow 8 61
SQL Server Remove all trailing commas 10 71
Need some help wiht :CAST AS Double 11 44
SQL Query with Sum and Detail rows 2 42
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now