Solved

Repair database without being attached (SQL 2005)

Posted on 2013-06-25
7
221 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

820 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