LearnItFirst User Forum

 New SQL Server 2008 DBA Course
Welcome Guest Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » Backup, Recovery and Disaster Recovery » ABOUT SUSPECT MODE
ABOUT SUSPECT MODE Options
Previous Topic · Next Topic
ashwin4all1@gmail.com
Posted: Friday, December 28, 2007 3:37:44 AM
Rank: Newbie

Joined: 12/28/2007
Posts: 0
Points: 6
Where do you live?: bangalore
Hi Man Am Shiv Here From India ,b'lore
I having a Problem
We Having A Small Database
nearly 4 to 15 gb
and our database is not replicated
but some time our database going to suspect mode
and another thing we using sql 2000 and we r installed a two instance and database is attached
in both instance . ok Whats the reason and how is the archtechuture

regards

Ashwin
Bangalore
Back to top
 
Scott Whigham
Posted: Wednesday, January 02, 2008 1:19:00 PM


Rank: Super Mod

Joined: 3/20/2006
Posts: 460
Points: 1,002
Where do you live?: Dallas, TX
 I would guess that the database files are unavailable. first thing to do is to check the logs - start in the Application Event Log and look for events under MSSQLSERVER. Report what they say back here
Back to top
Web  
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.