?
Solved

Repair database without being attached (SQL 2005)

Posted on 2013-06-25
7
Medium Priority
?
233 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 8

Assisted Solution

by:didnthaveaname
didnthaveaname earned 400 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 1600 total points
ID: 39277505
0
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39277864
Nice info! Helpful for me too!
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

801 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