Sql server database suspect mode error???

Vipin Mittal

8y879

What could be the reason for going into the server's suspense mode?????

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gajendra Jangid8y ago
Accepted answer
https://www.stellarinfo.com/blog/recover-sql-database-from-suspect-mode/
-1
Sanwar Ranwa8y ago
suspect mode error means the server suspects the primary filegroup of the database to be damaged. When SQL database goes into suspect mode, it becomes inaccessible. Under such a situation, neither will you be able to connect to the database nor will you be able to recover it during the server startup. You’ll need to perform some alternative recovery actions to resolve the issue
0
Dharmraj Thakur8y ago
Just replace your database name with this query...

Alter Database [dbname] set Emergency
Alter Database [dbname] set Single_User
dbcc checkdb ('dbname',repair) with no_infomsgs,all_errormsgs
Alter Database [dbname] set Multi_User
0
Rupesh Kahane8y ago
May be

1) A query gets suspended when it is requesting access to a resource that is currently not available. This can be a logical resource like a locked row or a physical resource like a memory data page. The query starts running again, once the resource becomes available.

2) High disk IO means that a lot of data pages need to be accessed to fulfill the request.

That is all that I can tell from the above screenshot. However, if I were to speculate, you probably have an IO subsystem that is too slow to keep up with the demand. This could be caused by missing indexes or an actually too slow disk. Keep in mind, that 15000 reads for a single OLTP query is slightly high but not uncommon.

3) The session is waiting for an event, such as I/O, to complete.

http://msdn.microsoft.com/en-us/library/ms174313.aspx
0