Database Discussion - Database in Suspect Mode

Print Page | Close Window

Database in Suspect Mode

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25473
Printed Date: 29 March 2026 at 5:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database in Suspect Mode

Posted By: iSec
Subject: Database in Suspect Mode
Date Posted: 22 March 2008 at 3:56pm

SQL Server 2000

Database: WWF

I accidentally deleted the folder where the database reside after taking down the SQL server. The database in Enterprise Manager appears as: db_name (Suspect)

I used a program to retreive the deleted files... I was able to retreive the .MDF file, but not the LDF.

Is there a way to restore the DB from an MDF file or am I screwed?

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Replies:

Posted By: michael
Date Posted: 24 March 2008 at 4:15pm

You can attach the MDF file, the LDF will be re-created. Just right click databases, not sure if you can do that via GUI in 2000 but there is a sproc that you can use.
basically delete the db you have in enterprise manager right now, attach the new one using the sproc and you should be good to go.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker