Question

Locked

SQL database goes in to suspect mode

By shellybhardwaj111 ·
Hi Friends,

I am facing the issue on SQL server database which is in suspect mode. What should I do to resolve it??

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

What issue?

by john.a.wills In reply to SQL database goes in to s ...

Who/what says the database is in suspect mode?

Collapse -

Reponse To Answer

by shellybhardwaj111 In reply to What issue?

Hello John,

Thanks for the quick response...

I tried to connect SQL database server & I found that SQL database goes in to suspect mode.

I read on many post that when I run following query, it get fixed:

EXEC sp_resetstatus ???yourDBname???;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(???yourDBname???)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (???yourDBname???, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

Ref: http://www.data-base-recovery.blogspot.in/2012/03/how-to-repair-sql-server-2008-r2.html
http://www.vnypatel.com/repair-sql-server-2008-r2-suspected-database

But the repair output was following error message:


Warning: You must recover this database prior to access.
Msg 8921, Level 16, State 1, Line 5
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Warning: The log for database 'ServeDB' has been rebuilt. Transactional consistency has been lost. The RESTORE chain was broken, and the server no longer
has context on the previous log files, so you will need to know what they were. You should run DBCC CHECKDB to validate physical consistency. The database has
been put in dbo-only mode. When you are ready to make the database available for use, you will need to reset database options and delete any extra log files.
Msg 8921, Level 16, State 1, Line 9
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.


How can I repair database? I want to know all possible reasons why sql server database going in to suspect mode.

Collapse -

I fear I cannot help

by john.a.wills In reply to SQL database goes in to s ...

but you do seem to have a lot of instructions from your attempt to repair. I suggest you follow them, even if you do not fully understand what has gone wrong. I recently got my printer working again by following instructions by email from the manufacturer, but I still do not know what the actual problem was. This should not happen in computing, but it often does.

Collapse -

Reponse To Answer

by shellybhardwaj111 In reply to I fear I cannot help

Thanks John for your response...

Do you have any idea about third party sql database recovery software?
Actually i read in many articles or fourms about it that the software repair suspected database. I have already follow all the steps to repair suspected database except sql database recovery software. I read above blog post, he recommended stellar phoenix sql recovery software. But I don't know how to use it? He also write in many post that it shows the preview of suspected database. Can you plz suggest me the proper steps?

Collapse -

Reponse To Answer

by shellybhardwaj111 In reply to I fear I cannot help

Do you have any idea about free sql recovery software? Because ii is paid...

Collapse -

Reponse To Answer

by shellybhardwaj111 In reply to I fear I cannot help

Hello John,

Plz suggest the answer or anyone who knows about it...

Collapse -

Why Not ues a Third party SQL Data Recovery Software?

by pauljasper In reply to SQL database goes in to s ...

Dear John,

You should be try a third party sql data recovery software in my opinion Kernel for SQL Recovery is the perfect solution to recover all corrupt or damaged MS SQL Server database files accurately. The SQL Server database files may get corrupt due to several reasons that is, virus attacks, abnormal system shut down, network issues etc. This tool efficiently recovers entire MDF files including triggers, tables, keys, procedures, indexes. It automatically rebuilds a new database MDF file making it the best tool among many others in the market.
For more Information please visit here...http://www.sqldatabaserepair.net
Thanks
Paul Jasper

Collapse -

Solution Is There? Just Take A Look!

by walllerry In reply to SQL database goes in to s ...

A database goes into suspect mode due to various reasons like database file damaged, database unable to open due to inaccessibility of files etc. So now for resolving this issue you can go through SQL Data Recovery Tool that will help you to recover SQL Server database from suspect status. For taking additional information visit at: http://www.sqlrecoverysoftware.org/

http://sqlserverrecovery.wordpress.com/2013/05/14/free-download-sql-file-repair-program/

Back to Networks Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums