{"id":8013,"date":"2017-07-11T06:15:44","date_gmt":"2017-07-11T06:15:44","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=8013"},"modified":"2026-04-01T06:30:36","modified_gmt":"2026-04-01T06:30:36","slug":"recover-sql-database-from-suspect-mode","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/","title":{"rendered":"How to Recover MS SQL Database from Suspect Mode?"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>After a long weekend, when I resumed office, I found myself in a difficult situation. There is a SQL database named <strong>BusinessOperation<\/strong> which went into the Suspect mode, halting all the operations. It contains some business critical information. As the first basic step, I restarted the SQL Server. Then, checked the status of database by running this command:<\/p><pre class=\"wp-block-code command_container\"><code>SELECT DATABASEPROPERTYEX (N'DemoSuspect', N'STATUS') AS Status;<\/code><\/pre><pre class=\"wp-block-code command_container\"><code>GO<\/code><\/pre><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"360\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Suspect-mode-1024x360.png\" alt=\"Recover MS SQL Database from Suspect Mode\" class=\"wp-image-190440 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Suspect-mode-1024x360.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Suspect-mode-300x105.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Suspect-mode-768x270.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Suspect-mode.png 1338w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p>Unfortunately, it was still in Suspect mode. I was not able to find out how to come out of this situation. So, I consulted other DBAs on the issue and they suggested some troubleshooting steps. I was able to recover my database from suspect mode by following those steps. Based on this experience, I have prepared this guide on how to recover MS SQL database from Suspect mode. Let&rsquo;s start from the basic.<\/p><h2 class=\"wp-block-heading\" id=\"what-is-suspect-mode-in-sql-server?\">What is Suspect Mode in SQL Server?<\/h2><p>Suspect mode is one of the states of MS SQL Server database. The SQL database goes into suspect mode when the database recovery fails or the primary data files are either missing or corrupted. In suspect mode, the database becomes inaccessible. This means you can neither connect to the database nor recover it during server startup. The database will remain in the suspect mode until it is restored to the normal state.<\/p><h2 class=\"wp-block-heading\" id=\"why-sql-database-goes-into-suspect-mode?\">Why SQL Database goes into Suspect Mode?<\/h2><p>The database may go into suspect mode due to one or more of the following reasons:<\/p><ul class=\"wp-block-list\">\n<li>The system&rsquo;s hard disk where database is stored is out of space.<\/li>\n\n\n\n<li>The <a href=\"https:\/\/www.stellarinfo.com\/article\/free-mdf-file-repair.php\">MDF database file is corrupted<\/a> or damaged.<\/li>\n\n\n\n<li>The primary file group of the database is corrupted or missing.<\/li>\n\n\n\n<li>The transaction log file is inaccessible or corrupted.<\/li>\n\n\n\n<li>MS SQL Server shuts down or crashes in the middle of a transaction.<\/li>\n\n\n\n<li>The database is terminated unexpectedly.<\/li>\n\n\n\n<li>SQL is unable to complete a rollback or roll-forward operation.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"solutions-to-recover-sql-database-from-suspect-mode\">Solutions to Recover SQL Database from Suspect Mode<\/h2><p>You can first check the database status. For this, open the&nbsp;<strong>SQL Server Management Studio (SSMS<\/strong>), go to the&nbsp;<strong>Object Explorer<\/strong>, and check the database. If the database is in suspect mode, check the&nbsp;SQL Server error log in SQL Server Management Studio (SSMS). This log contains all user-defined events and system events that will help you find the exact cause behind the database is in suspect mode issue. If corruption is the reason behind the database in the suspect mode issue, then follow the given methods.<\/p><h3 class=\"wp-block-heading\">Method 1: Restore Database from Backup<\/h3><p>If the database is corrupted or damaged, the easiest solution is to <a href=\"https:\/\/www.stellarinfo.com\/article\/restore-sql-server-database-from-bak-file.php\">restore SQL database from backup.<\/a> If you have an updated database backup file, then you can restore the backup file. To restore the database backup file, follow these steps:<\/p><ul class=\"wp-block-list\">\n<li>Open&nbsp;<strong>SQL Server Management Studio (SSMS)<\/strong>&nbsp;and connect to your server instance.<\/li>\n\n\n\n<li>From the standard bar, click&nbsp;<strong>&lsquo;New Query&rsquo;<\/strong>.<\/li>\n\n\n\n<li>In the &lsquo;<strong>Query Editor<\/strong>&rsquo; window, type the below command:<\/li>\n<\/ul><pre class=\"wp-block-code command_container\"><code>RESTORE DATABASE BusinessOperation &nbsp;&nbsp;<\/code><\/pre><pre class=\"wp-block-code command_container\"><code>FROM DISK = 'Z:\\SQLServerBackups\\ BusinessOperation .bak' ;<\/code><\/pre><ul class=\"wp-block-list\">\n<li>Next, try connecting to the database.<\/li>\n<\/ul><p>If your backup file is not updated or available, then follow the next method.<\/p><h3 class=\"wp-block-heading\">Method 2:&nbsp;Turn Off the Suspect Tag<\/h3><p>You can also try to turn off the suspect tag by using the <strong>EXEC sp_resetstatus &lsquo;dbNSFP&rsquo;<\/strong> command when your database enters suspect mode due to corruption or missing files. It is a stored procedure in the SQL Server system. This will reset the status of database from suspect to online. However, it does not resolve the corruption issue in database. Run this command to turn off the suspect tag:<\/p><p>EXEC sp_resetstatus &lsquo;BusinessOperations&rsquo;;<\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"544\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Turn-Off-the-Suspect-Tag-1-1024x544.png\" alt=\"Turn Off the Suspect Tag\" class=\"wp-image-190429 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Turn-Off-the-Suspect-Tag-1-1024x544.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Turn-Off-the-Suspect-Tag-1-300x159.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Turn-Off-the-Suspect-Tag-1-768x408.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Turn-Off-the-Suspect-Tag-1-1536x816.png 1536w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Turn-Off-the-Suspect-Tag-1-1568x833.png 1568w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Turn-Off-the-Suspect-Tag-1.png 1919w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p>It returns 0 if the command completes successfully and shows the message &ldquo;The suspect flag in the database &ldquo;<code>businessOperations&rdquo;<\/code> is already reset.&rdquo; If the database still fails to come online, then you can try the next method.<\/p><p><strong>Method 3: Use DBCC CHECKDB&nbsp;Command to Repair the Database<\/strong><\/p><p>You can use the <a href=\"https:\/\/www.stellarinfo.com\/blog\/how-to-repair-sql-database-using-dbcc-checkdb-command\/\">DBCC CHECKDB command<\/a> to repair the damaged SQL database and restore it from suspect mode to online mode. Following are the steps to repair the database using the DBCC CHECKDB command:<\/p><blockquote class=\"note_alert\">\n<p><strong><em>Note<\/em><\/strong><em>: It is suggested to create a backup of the SQL database before running this command.<\/em><\/p>\n<\/blockquote><p><strong>Step 1:<\/strong>&nbsp;Open&nbsp;SSMS&nbsp;and connect to the server instance.<\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"554\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/SSMS-1-1024x554.png\" alt=\"Open&nbsp;SSMS&nbsp;and connect to the server instance\" class=\"wp-image-190430 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/SSMS-1-1024x554.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/SSMS-1-300x162.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/SSMS-1-768x416.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/SSMS-1.png 1166w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p><strong>Step 2:<\/strong>&nbsp;Select the&nbsp;<strong>New Query<\/strong>&nbsp;option.<\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"378\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/New-Query-1024x378.png\" alt=\"Select the&nbsp;New Query&nbsp;option\" class=\"wp-image-190431 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/New-Query-1024x378.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/New-Query-300x111.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/New-Query-768x283.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/New-Query.png 1198w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p><strong>Step 3:<\/strong>&nbsp;In the&nbsp;<strong>Query Editor<\/strong>&nbsp;window, enter the following code to set the database to&nbsp;EMERGENCY mode:<\/p><pre class=\"wp-block-code command_container\"><code>ALTER DATABASE db_name SET EMERGENCY<\/code><\/pre><p>For example:<\/p><pre class=\"wp-block-code command_container\"><code>ALTER DATABASE BusinessOperations SET EMERGENCY<\/code><\/pre><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"962\" height=\"518\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/EMERGENCY-mode.png\" alt=\"set the database to&nbsp;EMERGENCY mode\" class=\"wp-image-190432 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/EMERGENCY-mode.png 962w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/EMERGENCY-mode-300x162.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/EMERGENCY-mode-768x414.png 768w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/figure><p><strong>Step 4:<\/strong>&nbsp;Now, run the following DBCC CHECKDB command. This command will check the integrity\/consistency of the database. It will also report the consistency errors (if found) in the database and recommend the repair option.<\/p><pre class=\"wp-block-code command_container\"><code>DBCC CHECKDB (BusinessOperations)<\/code><\/pre><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"448\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/DBCC-CHECKDB-command-1024x448.png\" alt=\"DBCC CHECKDB (BusinessOperations)\" class=\"wp-image-190433 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/DBCC-CHECKDB-command-1024x448.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/DBCC-CHECKDB-command-300x131.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/DBCC-CHECKDB-command-768x336.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/DBCC-CHECKDB-command.png 1290w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p><strong>Step 5:<\/strong>&nbsp;Next, set the database to Single User mode to prevent other users from making any changes to the database during the repair process. To set the database to Single User mode&nbsp;and roll back the previous transactions, execute the below command:<\/p><pre class=\"wp-block-code command_container\"><code>ALTER DATABASE BusinessOperations SET SINGLE_USER WITH ROLLBACK IMMEDIATE<\/code><\/pre><p><strong>Step 6:<\/strong>&nbsp;After putting the database in SINGLE USER mode, run the DBCC CHECKDB command with the suggested repair option. If the REPAIR_REBUILD option is suggested, then run DBCC CHECKDB command as given below. This option can quickly repair missing rows in non-clustered indexes.<\/p><pre class=\"wp-block-code command_container\"><code>DBCC CHECKDB (&lsquo;BusinessOperations&rsquo;, REPAIR_REBUILD)<\/code><\/pre><p>If the REPAIR_ALLOW_DATA_LOSS is suggested as a minimum level of repair, then run the command as given below:<\/p><pre class=\"wp-block-code command_container\"><code>DBCC CHECKDB (BusinessOperations, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;<\/code><\/pre><blockquote class=\"note_alert\">\n<p><strong><em>Note<\/em><\/strong><em>: The DBCC CHECKDB command with REPAIR_ALLOW_DATA_LOSS option usually helps to bring the database to a consistent state. But, this command results in data loss.<\/em><\/p>\n<\/blockquote><p><strong>Step 7:<\/strong>&nbsp;When the database is repaired, bring it back to Multi-User mode. To do so, execute the below command:<\/p><pre class=\"wp-block-code command_container\"><code>ALTER DATABASE BusinessOperations SET MULTI_USER<\/code><\/pre><p>Now, you should be able to connect to the database.<\/p><p>Sometimes, DBCC CHECKDB fails to repair the database and displays an error like:<\/p><pre class=\"wp-block-code command_container\"><code>Msg 945, Level 14, State 2, Line 1<br>Database 'BusinessOperations' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.<\/code><\/pre><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"544\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/error-1024x544.png\" alt=\"Error when DBCC CHECKDB fails\" class=\"wp-image-190434 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/error-1024x544.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/error-300x159.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/error-768x408.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/error-1536x816.png 1536w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/error-1568x833.png 1568w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/error.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p>To fix this error, read our guide on <a href=\"https:\/\/www.stellarinfo.com\/article\/sql-error-945.php\"><strong>How to Fix SQL Error 945 &ndash; Database cannot be Opened due to Inaccessible Files<\/strong><\/a>.<\/p><p><strong>Method 3: Use a Professional MS SQL Repair Tool<\/strong><\/p><p>The DBCC CHECKDB command can repair the database and helps you recover the database from suspect mode. However, it does not guarantee the accuracy of repaired data in the database or may fails in certain scenarios. To avoid data loss and quickly repair the corrupt SQL database, you can use Stellar Repair for MS SQL &ndash; a <a href=\"https:\/\/www.stellarinfo.com\/sql-database-repair.php\">professional SQL database repair tool<\/a>. The tool can repair the database (MDF\/NDF) file and recover all the objects, including tables, triggers, stored procedures, and indexes with complete precision and integrity. It can help fix&nbsp;common SQL database corruption errors. The software is compatible with SQL 2022, 2019, 2017, and earlier versions.<\/p><p>Let&rsquo;s see how to repair SQL database with Stellar Repair for MS SQL and recover it from suspect mode.<\/p><blockquote class=\"note_alert\">\n<p><strong><em>Note:&nbsp;<\/em><\/strong><em>Close the server instance before running the software.<\/em><\/p>\n<\/blockquote><p><strong>Step 1:<\/strong>&nbsp;Download, install, and run&nbsp;<strong>Stellar Repair for MS SQL<\/strong>&nbsp;software.<\/p><p><strong>Step 2:<\/strong>&nbsp;From the&nbsp;<strong>Select Database<\/strong>&nbsp;window, choose&nbsp;<strong>Browse&nbsp;<\/strong>or&nbsp;<strong>Search<\/strong>&nbsp;to select the SQL database file (.mdf).<\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/select-the-SQL-database-file-.mdf_-1024x543.png\" alt=\"select the SQL database file (.mdf)\" class=\"wp-image-190436 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/select-the-SQL-database-file-.mdf_-1024x543.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/select-the-SQL-database-file-.mdf_-300x159.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/select-the-SQL-database-file-.mdf_-768x408.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/select-the-SQL-database-file-.mdf_.png 1432w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p><strong>Step 3:<\/strong>&nbsp;Once the file is selected, click&nbsp;<strong>Repair<\/strong>.<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"213\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/click-Repair.png\" alt=\"Once the file is selected, click&nbsp;Repair\" class=\"wp-image-190437 apply-gradient-on-post-images\" style=\"aspect-ratio:1.8779986794805956;width:840px;height:auto\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/click-Repair.png 400w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/click-Repair-300x160.png 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/figure><blockquote class=\"note_alert\">\n<p><strong><em>Note:&nbsp;<\/em><\/strong><em>Uncheck the &lsquo;Include Deleted Records&rsquo; checkbox if you don&rsquo;t want the deleted records to be recovered.<\/em><\/p>\n<\/blockquote><p><strong>Step 4:&nbsp;<\/strong>When the repair process is complete, it will display a &ldquo;Selected MS SQL database repaired successfully&rdquo; message. Click&nbsp;<strong>OK<\/strong>.<\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"545\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/preview-the-objects-1024x545.png\" alt=\"Selected MS SQL database repaired successfully\" class=\"wp-image-190438 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/preview-the-objects-1024x545.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/preview-the-objects-300x160.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/preview-the-objects-768x408.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/preview-the-objects.png 1431w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p><strong>Step 5:<\/strong>&nbsp;The software will present all the recoverable SQL database objects. You can preview the objects.<\/p><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"547\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Repaired-successfully-1024x547.png\" alt=\"Preview recoverable SQL database objects\" class=\"wp-image-190439 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Repaired-successfully-1024x547.png 1024w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Repaired-successfully-300x160.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Repaired-successfully-768x410.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Repaired-successfully.png 1430w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p><strong>Step 6:<\/strong>&nbsp;Click&nbsp;<strong>Save<\/strong>&nbsp;on&nbsp;<strong>File&nbsp;<\/strong>menu to save the repaired file.<\/p><p><strong>Step 7:<\/strong>&nbsp;On the&nbsp;<strong>Save Database<\/strong>&nbsp;window, under the&nbsp;<strong>Saving Option<\/strong>, select&nbsp;<strong>New Database, Live Database,&nbsp;<\/strong>or<strong>&nbsp;Other Formats<\/strong>. Click&nbsp;<strong>Next<\/strong>.<\/p><p><strong>Step 8:<\/strong>&nbsp;On the next window, fill in the details required under <strong>Connect To Server<\/strong> and click on the <strong>Next<\/strong> option.<\/p><p><strong>Step 9:<\/strong>&nbsp;Select the&nbsp;<strong>Save Mode<\/strong>&nbsp;and click&nbsp;<strong>Save<\/strong>.<\/p><p>When the database is repaired, open SSMS and attach the repaired database file. You will now be able to access the database.&nbsp;<\/p><h2 class=\"wp-block-heading\" id=\"conclusion\"><strong>Conclusion<\/strong><\/h2><p>Above, we have discussed the solutions&nbsp;to recover MS SQL database from suspect mode. The best approach is to restore the database from a healthy backup. If you don&rsquo;t have a healthy or updated backup, then use the DBCC CHECKDB command to repair it. However, the DBCC CHECKDB command with REPAIR_ALLOW_DATA_LOSS option can result in data loss. A better option is to use Stellar Repair for MS SQL &ndash; a specialized&nbsp;SQL database repair software that can repair the database without any data loss and help you recover the database from suspect mode.<\/p><p>Read Suspect Mode Case Study: &nbsp;<a href=\"https:\/\/www.stellarinfo.com\/casestudy\/saint-robert-police-department-repairs-corrupt-ms-sql-database\">St. Robert, MO, USA Police Department Repairs Large MS SQL Database by using Stellar Toolkit for MS SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After a long weekend, when I resumed office, I found myself in&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\">Continue reading <span class=\"screen-reader-text\">How to Recover MS SQL Database from Suspect Mode?<\/span><\/a><\/p>\n","protected":false},"author":82,"featured_media":171730,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[598,597],"class_list":["post-8013","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-recovery","tag-ms-sql","tag-recover-ms-sql-database-from-suspect-mode","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Recover MS SQL Database from Suspect Mode<\/title>\n<meta name=\"description\" content=\"Solutions to recover SQL database from Suspect Mode - Restore Database from Backup, Turn Off Suspect Tag, Use DBCC CHECKDB Command or by using MS SQL Repair Tool\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Recover MS SQL Database from Suspect Mode\" \/>\n<meta property=\"og:description\" content=\"Solutions to recover SQL database from Suspect Mode - Restore Database from Backup, Turn Off Suspect Tag, Use DBCC CHECKDB Command or by using MS SQL Repair Tool\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-11T06:15:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-01T06:30:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Monika Dadool\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Monika Dadool\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\"},\"author\":{\"name\":\"Monika Dadool\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\"},\"headline\":\"How to Recover MS SQL Database from Suspect Mode?\",\"datePublished\":\"2017-07-11T06:15:44+00:00\",\"dateModified\":\"2026-04-01T06:30:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\"},\"wordCount\":1441,\"commentCount\":35,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg\",\"keywords\":[\"MS SQL\",\"Recover MS SQL Database from Suspect Mode\"],\"articleSection\":[\"SQL Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\",\"name\":\"How to Recover MS SQL Database from Suspect Mode\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg\",\"datePublished\":\"2017-07-11T06:15:44+00:00\",\"dateModified\":\"2026-04-01T06:30:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\"},\"description\":\"Solutions to recover SQL database from Suspect Mode - Restore Database from Backup, Turn Off Suspect Tag, Use DBCC CHECKDB Command or by using MS SQL Repair Tool\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg\",\"width\":1000,\"height\":600,\"caption\":\"Recover MS SQL Database from Suspect Mode\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Recover MS SQL Database from Suspect Mode?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd\",\"name\":\"Monika Dadool\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g\",\"caption\":\"Monika Dadool\"},\"description\":\"Monika Dadool is a Senior Content Writer at Stellar with over 5 years of experience in technical writing. She is a tech enthusiast and expert who specializes in writing about SQL Server, MySQL Server, MariaDB Server, Microsoft Access, Active Directory, email recovery, Microsoft 365, pattern recognition, machine learning, data recovery, file repair, and operating systems like Linux, Windows, and Mac. She also writes about accounting software such as QuickBooks and Sage 50, as well as web-scripting languages like HTML, JavaScript, Python, PHP, Visual Basic, ASP.NET, and AJAX. Monika is passionate about researching and exploring new technologies, and she enjoys developing engaging technical blogs that help organizations and database administrators resolve various issues. When she's not creating content, you can find her on social media, watching web series, reading books, or exploring new food recipes.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/monika-dadool-105a87163\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/monika\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Recover MS SQL Database from Suspect Mode","description":"Solutions to recover SQL database from Suspect Mode - Restore Database from Backup, Turn Off Suspect Tag, Use DBCC CHECKDB Command or by using MS SQL Repair Tool","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/","og_locale":"en_US","og_type":"article","og_title":"How to Recover MS SQL Database from Suspect Mode","og_description":"Solutions to recover SQL database from Suspect Mode - Restore Database from Backup, Turn Off Suspect Tag, Use DBCC CHECKDB Command or by using MS SQL Repair Tool","og_url":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2017-07-11T06:15:44+00:00","article_modified_time":"2026-04-01T06:30:36+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg","type":"image\/jpeg"}],"author":"Monika Dadool","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Monika Dadool","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/"},"author":{"name":"Monika Dadool","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd"},"headline":"How to Recover MS SQL Database from Suspect Mode?","datePublished":"2017-07-11T06:15:44+00:00","dateModified":"2026-04-01T06:30:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/"},"wordCount":1441,"commentCount":35,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg","keywords":["MS SQL","Recover MS SQL Database from Suspect Mode"],"articleSection":["SQL Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/","url":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/","name":"How to Recover MS SQL Database from Suspect Mode","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg","datePublished":"2017-07-11T06:15:44+00:00","dateModified":"2026-04-01T06:30:36+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd"},"description":"Solutions to recover SQL database from Suspect Mode - Restore Database from Backup, Turn Off Suspect Tag, Use DBCC CHECKDB Command or by using MS SQL Repair Tool","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/07\/Recover-MS-SQL-Database-from-Suspect-Mode.jpg","width":1000,"height":600,"caption":"Recover MS SQL Database from Suspect Mode"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Recover MS SQL Database from Suspect Mode?"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/02a465e9b5b4912eafedd1ae248558fd","name":"Monika Dadool","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7d22d2cc256776033dcf284e9c6b96fcf19473429aa25ea91b3f7561ae5e8b7a?s=96&d=mm&r=g","caption":"Monika Dadool"},"description":"Monika Dadool is a Senior Content Writer at Stellar with over 5 years of experience in technical writing. She is a tech enthusiast and expert who specializes in writing about SQL Server, MySQL Server, MariaDB Server, Microsoft Access, Active Directory, email recovery, Microsoft 365, pattern recognition, machine learning, data recovery, file repair, and operating systems like Linux, Windows, and Mac. She also writes about accounting software such as QuickBooks and Sage 50, as well as web-scripting languages like HTML, JavaScript, Python, PHP, Visual Basic, ASP.NET, and AJAX. Monika is passionate about researching and exploring new technologies, and she enjoys developing engaging technical blogs that help organizations and database administrators resolve various issues. When she's not creating content, you can find her on social media, watching web series, reading books, or exploring new food recipes.","sameAs":["https:\/\/www.linkedin.com\/in\/monika-dadool-105a87163\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/monika\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/8013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=8013"}],"version-history":[{"count":106,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/8013\/revisions"}],"predecessor-version":[{"id":191243,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/8013\/revisions\/191243"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/171730"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=8013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=8013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=8013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}