Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Database in Suspect Mode
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database in Suspect Mode
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Topic: Database in Suspect Mode
    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
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.