ABOUT SUSPECT MODE - Backup, Recovery and Disaster Recovery - LearnSqlServer.com's SQL Server Forums

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » 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
Location: 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

Scott Whigham

Posted: Wednesday, January 02, 2008 1:19:00 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: 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

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.