Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 5th, 2003, 01:47 AM
Authorized User
  
Join Date: Jun 2003
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Suspect
I am running SQL Server 2000 with sp3 and this morning I got the following error messages: DB_name (Suspect). Now what do you do when your database is under suspect? I was thinking to drop and restore a clean backup am I right? What are the reasons for db to be suspect? I shall remain.

Regards,

CarlWalden
__________________
CarlWalden
 
Old June 5th, 2003, 01:54 AM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 215
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Check out "resetting suspect status" in SQL Server Books Online (2000 SP3 edition).

As for why it happens, BOL for SQL Server 7 says:
A database can become suspect if one of these conditions is true:
-If one or more database files are not available.
-If the entire database is not available.
-If one or more database files are corrupted.
-If a database resource is being held by the operating system.

Sounds like 4 fits the bill best here.

regards
David Cameron





Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft JET Database Database Engine (0x80040E09 cannielynn0312 Classic ASP Professional 2 December 17th, 2007 02:50 AM
Suspect database PSilva SQL Server 2000 2 April 13th, 2007 05:44 AM
SQL 2005 Express database mark as 'SUSPECT' dex_bg SQL Server 2005 4 September 19th, 2006 04:07 AM
Copying Table From one Database To Anoter Database jayanth_nadig VB Databases Basics 1 June 19th, 2006 02:39 PM
causes and recovery from suspect mode pinkuisadear SQL Server 2000 0 February 19th, 2005 10:34 AM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.