Solved

SQl Server Instance labeled 'Suspect'

Posted on 2014-03-08
2
521 Views
Last Modified: 2014-03-09
I dropped a database into my sql server data folder to run a proprietary application on (I do this routinely on other computers) but the application won't open.  I went into the SQL Server Management Studio and the database is listed as "Suspect".  How can I resolve this?

It's a Windows 7 machine.
0
Comment
Question by:Bob Schneider
[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
2 Comments
 
LVL 82

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 39915321
Best option is to restore from a backup.  First off stop the SQL server services and copy your suspect database mdf and log ldf files

Sql Server <= 2005, detach and reattach and see if this resolves the issue.
From Sql Server Managment.. replace suspect with your actual values same goes for the path
EXEC sp_attach_db @dbname = 'Suspect',
    @filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Suspect.mdf',
    @filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Suspect_log.ldf';
GO

Open in new window


You will at least see if there are any error messages.
Lets see if the log file is damaged.. This will recreate a new log file
CREATE DATABASE [DemoSuspect] ON
    (NAME = Suspect',
    FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Suspect.mdf')
FOR ATTACH_REBUILD_LOG
GO

Open in new window


There are a few more steps i.e. Emergency mode... this is not for the faint of heart and doesn't guarantee all the data will be recovered and it is strictly a last resort option

http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/
0
 

Author Closing Comment

by:Bob Schneider
ID: 39915774
Awesome help.  Thanks!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

627 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