SQL Server Performance Forum – Threads Archive
Can I Convert Suspect DB Mode to Normal DB Mode?
Hi,<br /><br />I created one database (General). After sometime I removed the database (General).<br /><br />I again created the new database with old removed database name (General). <br /><br />After that database was created but it was showing the supect mode.<br /><br />I’m not able to open database properties or drop etcccc………<br /><br />I like to convert that database suspect mode to normal mode.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />] I hope anyone will provide me a good suggestion.<br /><br /><br /><br />Amit Kumar<br />Mob.: 9873812005
hi try the steps in the article written by pop rivett below. Hope that helps… http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/
First check what is cuasing the database to go into suspect…
Check the sql error log and application for more details… You can’t update the system tables unless you use DAC connection….
Check ALTER DATABASE systax for EMERGENCY option to change db to emergency mode…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by BulentGucuk</i><br /><br />hi try the steps in the article written by pop rivett below. Hope that helps…<br /><br /<a target="_blank" href=http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/>http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><br /><br /><br /><br /><br /><br />———————————————<br />Thanks for reply<br />Take Care, If you find any kind of issue on sql server. <br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]Please reply to me.<br /><br /><br /><br />Amit Kumar<br />Mob.: 9873812005
Your reply doesn’t relates that whether you have got relevant reply or not. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>