home
training courses
why choose us?
solutions
support
company
LearnItFirst User Forum
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
Users browsing this topic
Guest
Forum Jump
SQL Server Database Administration
- General SQL Database Question & Answer
- Backup, Recovery and Disaster Recovery
- SQL Server Security
- Integration Services (SSIS) and DTS
Transact-SQL Programming
- DML (SELECT, INSERT, UPDATE, DELETE) Questions
- Stored Procedures, Triggers, & Functions
SQL Server Scripts, Code Samples and SSMS Custom Reports
- All SQL Server Versions
- SQL Server 2005/2008
- SQL Server Management Studio Custom Reports
Customer Service
- Video Requests
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.
SQL Server 2005 DBA Training Videos
SQL Server 2008 DBA Training Videos
Watch this topic
RSS Feed
Email this topic
Print this topic
Threaded
Normal