Solved

Repair database without being attached (SQL 2005)

Posted on 2013-06-25
7
224 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 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Upgrading SQL 2005 Express to 2008 R2 Express 31 203
Table create permissions on SQL Server 2005 9 45
kill process lock Sql server 9 79
How can I use this function? 3 35
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

734 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