Solved

SQl Server Instance labeled 'Suspect'

Posted on 2014-03-08
2
513 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
2 Comments
 
LVL 79

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

832 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