{"id":11157,"date":"2017-09-20T05:29:52","date_gmt":"2017-09-20T05:29:52","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=11157"},"modified":"2022-08-03T04:37:34","modified_gmt":"2022-08-03T04:37:34","slug":"fix-sql-server-2008-r2-error-926","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/","title":{"rendered":"How to Deal with SQL Server 2008 R2 Error 926?"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><h2 class=\"wp-block-heading\" id=\"about-sql-server-error-926\"><strong>About SQL Server Error 926<\/strong><\/h2><p>Suppose you write an SQL query and are ready to execute it in SQL Server 2008 R2; but as you input the code, you get the following error message:<\/p><p><em><strong>Database &lsquo;msdb&rsquo; cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926).<\/strong><\/em><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/SQL-database-error-926.jpg\" alt=\"Microsoft SQL Server, Error: 926 Message\"><\/figure>\n<\/div><p class=\"has-text-align-center\">Figure 1 &ndash; Microsoft SQL Server, Error: 926 Message<\/p><p><strong>The above error message indicates that &lsquo;database is marked as suspect due to failed recovery process&rsquo;, which prevents the database from opening. So, you will need to repair or <\/strong><a href=\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-suspect-mode\/\" target=\"_blank\" rel=\"noreferrer noopener\">recover MS SQL database from suspect mode<\/a> to make it accessible again. &nbsp;<strong><\/strong><\/p><h2 class=\"wp-block-heading\" id=\"following-are-some-operations-that-result-in-sql-error-926:\"><strong>Following are some operations that result in SQL error 926:<\/strong><strong><\/strong><\/h2><ul class=\"wp-block-list\"><li>Starting up a SQL Server instance<\/li><li>SQL database is not attached properly<\/li><li>Using the RESTORE database or RESTORE LOG commands<\/li><\/ul><h2 class=\"wp-block-heading\" id=\"how-to-fix-sql-server-2008-r2-error-926?\"><strong>How to Fix SQL Server 2008 R2 Error 926?<\/strong><strong><\/strong><\/h2><p>Check the SQL Server error log to identify what caused the error. If the recovery failed due to an I\/O error (a torn page) or any other hardware issue, try resolving the hardware issue first to fix the error. If this doesn&rsquo;t work, there must be some form of&nbsp;<strong>database corruption<\/strong>. In that case, try&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/restore-a-database-backup-using-ssms?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">restoring the database from the last known database backup<\/a>.<\/p><p>If you don&rsquo;t have recent backup or the backup is corrupt, set the database in EMERGENCY mode and try the <a href=\"https:\/\/www.stellarinfo.com\/blog\/how-to-repair-sql-database-using-dbcc-checkdb-command\/\" target=\"_blank\" rel=\"noreferrer noopener\">DBCC CHECKDB<\/a> repair operations. Doing so will help you restore access to the&nbsp;<strong>database marked as suspect<\/strong>. But, before attempting this solution, try the following tricks to fix<strong>&nbsp;Microsoft SQL Server 2008 R2 Error 926 MSDB<\/strong>:<\/p><ol class=\"wp-block-list\" type=\"1\"><li><em>Refresh the SQL connection.<\/em><em><\/em><\/li><li><em>Disconnect and reconnect the SQL connection.<\/em><em><\/em><\/li><li><em>Restart the service for MSSQLSERVER.<\/em><em><\/em><\/li><li><em>Restart the SQL Server Management Studio (SSMS).<\/em><em><\/em><\/li><li><em>Restart your desktop.<\/em><em><\/em><\/li><\/ol><p>If none of the above tricks help resolve the error, perform these steps:<\/p><h3 class=\"wp-block-heading\" id=\"h-step-1-use-emergency-mode-to-repair-a-suspect-database\"><strong>Step 1: Use EMERGENCY Mode to Repair a Suspect Database<u><\/u><\/strong><\/h3><p>Open a new query window in SSMS, and then run the following commands:<\/p><p><em><strong>Note:<\/strong><\/em><em>&nbsp;You can also use the<\/em><strong><em>&nbsp;&lsquo;sp_resetstatus&rsquo;<\/em><\/strong><em>&nbsp;stored procedure to turn off the suspect flag on a database. For detailed information, refer to this <\/em><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-stored-procedures\/sp-resetstatus-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a><em>.<\/em><\/p><figure class=\"wp-block-table\"><table><tbody><tr><td><strong>ALTER DATABASE DB_Name SET EMERGENCY;<\/strong><strong><\/strong><\/td><\/tr><\/tbody><\/table><\/figure><p>This command puts the database in&nbsp;<strong>EMERGENCY<\/strong>&nbsp;mode. In this mode, users only get read-only permission to access the database.<\/p><p><strong><em>Note:<\/em><\/strong><em>&nbsp;Members of the sysadmin fixed server can only access this right.<\/em><\/p><figure class=\"wp-block-table\"><table><tbody><tr><td><strong>DBCC CHECKDB (&lsquo;DB_Name&rsquo;);<\/strong><strong><\/strong><\/td><\/tr><\/tbody><\/table><\/figure><p>The above command helps check the integrity of all database objects.<\/p><figure class=\"wp-block-table\"><table><tbody><tr><td><strong>ALTER DATABASE DB_Name SET SINGLE_USER WITH ROLLBACK IMMEDIATE;<\/strong><strong><\/strong><\/td><\/tr><\/tbody><\/table><\/figure><p>The command sets the database in &lsquo;<em>single user mode<\/em>&rsquo;.<\/p><figure class=\"wp-block-table\"><table><tbody><tr><td><strong>DBCC CHECKDB (&lsquo;DB_Name&rsquo;, REPAIR_ALLOW_DATA_LOSS);<\/strong><strong><\/strong><\/td><\/tr><\/tbody><\/table><\/figure><p>This DBCC CHECKDB command will help repair the errors in SQL Server 2008 R2.<\/p><figure class=\"wp-block-table\"><table><tbody><tr><td><strong>ALTER DATABASE DB_Name SET MULTI_USER;<\/strong><strong><\/strong><\/td><\/tr><\/tbody><\/table><\/figure><p>With this command, the SQL Server database will be set in multi-user mode, allowing multiple users to access the database.<\/p><p>After executing all of the above commands, check if you can access the database. If you can, put the db back in normal mode.<\/p><p><strong>Read this:&nbsp;<\/strong><a href=\"https:\/\/www.stellarinfo.com\/blog\/recover-sql-database-from-emergency-mode-to-normal-mode\/\" target=\"_blank\" rel=\"noreferrer noopener\">Recover SQL Database from Emergency Mode to Normal Mode<\/a><\/p><p>If this step fails, proceed with the next step.<\/p><h3 class=\"wp-block-heading\" id=\"h-step-2-move-and-detach-msdb-file\"><strong>Step 2 <\/strong><strong>&ndash;<\/strong><strong> Move and Detach <\/strong>MSDB <strong>File<\/strong><\/h3><p>You can try to recover suspect MSDB database by moving and detaching the MSDB data and log files. For this, you can use SQL Server Management Studio (SSMS) or T-SQL:<\/p><p><strong>Using SSMS<\/strong><\/p><ol class=\"wp-block-list\" type=\"1\"><li>Open&nbsp;<strong>Object Explorer in SSMS,&nbsp;<\/strong>right-click the connected SQL Server instance and then&nbsp;<strong>click Stop<\/strong>.<\/li><\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/Stop.jpg\" alt=\"Stop SQL Server Instance\"><\/figure>\n<\/div><p><\/p><p class=\"has-text-align-center\">Figure 2 &ndash; Stop SQL Server Instance<\/p><p>2.<strong>&nbsp;<\/strong>Open Control panel, browse and select&nbsp;<strong>administrative tools<\/strong>, and then click&nbsp;<strong>Services.<\/strong><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/Services.jpg\" alt=\"SQL Server Services\"><\/figure>\n<\/div><p><\/p><p class=\"has-text-align-center\">Figure 3 &ndash; SQL Server Services<\/p><p>3. In <strong>&lsquo;Services&rsquo;<\/strong> dialog box, locate and right-click on SQL Server (MSSQLSERVER), and then click <strong>Stop.<\/strong><\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/Stop-Services.jpg\" alt=\"Stellar\" class=\"wp-image-76607 apply-gradient-on-post-images\"><\/figure>\n<\/div><p class=\"has-text-align-center\">Figure 4 &ndash; Stop SQL Server Service<\/p><p>4<strong>.<\/strong>&nbsp;Open&nbsp;<strong>C:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\DATA.<\/strong><\/p><p>5. Move&nbsp;the MSDB data file (.<strong>mdf)<\/strong>&nbsp;&amp;&nbsp;log file (<strong>.ldf)<\/strong> to any other folder or location.<\/p><p>6. Copy the .mdf and .ldf files from the new location to their original location by browsing the following path:<\/p><p><strong>C:\\Program Files\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\DATA<\/strong><\/p><p>7.<strong>&nbsp;<\/strong>Restart SQL Server Service.<\/p><p>8. Refresh the&nbsp;<strong>database<\/strong>, and detach the&nbsp;<strong>MSDB file<\/strong>.&nbsp;<\/p><p><strong>Using T-SQL<\/strong><\/p><p>You can also recover the MSDB database in suspect mode by executing the below T-SQL query:<\/p><figure class=\"wp-block-table\"><table><tbody><tr><td><strong>EXEC sp_resetstatus &lsquo;db_name&rsquo;<\/strong> <strong>ALTER DATABASE db_name SET EMERGENCY<\/strong> <strong>DBCC CHECKDB (&lsquo;db_name&rsquo;)<\/strong> <strong>ALTER DATABASE db_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE<\/strong> <strong>DBCC CHECKDB (&lsquo;db_name&rsquo;, REPAIR_ALLOW_DATA_LOSS)<\/strong> <strong>ALTER DATABASE db_name SET MULTI_USER<\/strong><\/td><\/tr><\/tbody><\/table><\/figure><p><strong><em>Note:<\/em><\/strong><em> Replace db_name with the name of your database marked as suspect.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<\/em><\/p><p>The above code will turn off the suspect flag on the database and put it in emergency mode. Next, it will bring the database to single-user mode, repair it, and will put the database to multi-user mode.<\/p><h4 class=\"wp-block-heading\" id=\"h-limitations-of-resolving-sql-server-error-926-manually\"><strong>Limitations of Resolving SQL Server Error 926 Manually<\/strong><\/h4><p>There are a few downsides to using the aforementioned manual workarounds to&nbsp;<strong>resolve SQL error 926<\/strong>:<\/p><ul class=\"wp-block-list\"><li>DBCC CHECKDB may fail to effectively repair a large-sized, severely corrupt SQL database.<\/li><li>DBCC CHECKDB &lsquo;<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/database-console-commands\/dbcc-checkdb-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">REPAIR_ALLOW_DATA_LOSS<\/a>&rsquo; command may cause some data loss.<\/li><\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/stellarinfo.com\/blog\/wp-content\/uploads\/2021\/01\/DBCC-CHECKDB-REPAIR-ALLOW-DATA-LOSS-WARNING.png\" alt=\"DBCC CHECKDB REPAIR ALLOW DATA LOSS WARNING\"><\/figure>\n<\/div><ul class=\"wp-block-list\"><li>Loss of data integrity.<\/li><li>The above steps may take too much time to resolve the&nbsp;<strong>Microsoft SQL server error 926<\/strong>.<\/li><\/ul><h2 class=\"wp-block-heading\" id=\"alternative-solution-to-fix-sql-server-2008-r2-error-926\"><strong>Alternative Solution to Fix SQL Server 2008 R2 Error 926<\/strong><\/h2><p><a href=\"https:\/\/www.stellarinfo.com\/sql-recovery.php\" target=\"_blank\" rel=\"noreferrer noopener\">SQL database recovery&nbsp;software<\/a> can resolve any error, including error 926 in SQL Server causing databases to become inaccessible.<\/p><p>Also, the SQL database repair software can help you overcome the limitations of the above-discussed solutions, here&rsquo;s how:<\/p><ul class=\"wp-block-list\"><li>It specializes in the repair and recovery of large-sized, severely corrupt SQL Server databases.<\/li><li>Laced with powerful algorithms, the software can parse a SQL database and reconstruct all its objects into their original state.<\/li><li>Maintain the integrity of database structure and its objects.<\/li><li>Reduces the manual efforts and time a user spends in making SQL Server databases and objects accessible.<\/li><li>Recommended by Microsoft SQL MVPs. Check the MVP review from&nbsp;<a href=\"https:\/\/www.scarydba.com\/2020\/09\/23\/review-stellar-repair-for-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/li><\/ul><p>You can download the demo version of the <a href=\"https:\/\/www.stellarinfo.com\/sql-database-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">SQL database repair software<\/a> to ascertain its effectiveness.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/cloud.stellarinfo.com\/StellarRepairforMSSQL-Blog.exe\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/images\/free-download-windows.png\" alt=\"free download\"><\/a><\/figure>\n<\/div><h3 class=\"wp-block-heading\" id=\"h-key-features-of-stellar-repair-for-ms-sql\"><strong>&nbsp;Key Features of Stellar Repair for MS SQL<\/strong><strong><\/strong><\/h3><ul class=\"wp-block-list\"><li>Repairs corrupt MDF and NDF files<\/li><li>Supports all versions of SQL Server<\/li><li>Recovers all database objects, including tables, indexes, triggers, rules, keys, etc.<\/li><li>Allows recovery of deleted SQL Server records<\/li><li>Supports multiple file saving options like MS SQL, CSV, HTML, and XLS<\/li><li>Capable of resolving&nbsp;<a href=\"https:\/\/www.stellarinfo.com\/support\/kb\/index.php\/article\/common-sql-database-corruption-errors-causes-solutions\" target=\"_blank\" rel=\"noreferrer noopener\">all type of corruption errors<\/a>.<\/li><\/ul><h2 class=\"wp-block-heading\" id=\"conclusion\"><strong>Conclusion<\/strong><strong><\/strong><\/h2><p>You can use manual fixes and software to deal with&nbsp;<strong>SQL Server 2008 R2 Error 926<\/strong>. While the manual fixes may help you fix the error, they may take considerable time and effort in resolving the error. This increases server downtime, leading to productivity loss and chances of data loss. However, using SQL repair software may help you restore the database in minimal time without the fear of losing any data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>About SQL Server Error 926 Suppose you write an SQL query and&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/\">Continue reading <span class=\"screen-reader-text\">How to Deal with SQL Server 2008 R2 Error 926?<\/span><\/a><\/p>\n","protected":false},"author":15,"featured_media":11169,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-11157","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-recovery","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 Fix Microsoft SQL Server 2008 R2 Error 926?<\/title>\n<meta name=\"description\" content=\"Learn how to fix Microsoft SQL Server 2008 R2 Error 926 manually using step-wise instructions or an automated method explained in this blog.\" \/>\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\/fix-sql-server-2008-r2-error-926\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix Microsoft SQL Server 2008 R2 Error 926?\" \/>\n<meta property=\"og:description\" content=\"Learn how to fix Microsoft SQL Server 2008 R2 Error 926 manually using step-wise instructions or an automated method explained in this blog.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-20T05:29:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-03T04:37:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.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=\"Priyanka Chauhan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@priyanka66\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Chauhan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/\"},\"author\":{\"name\":\"Priyanka Chauhan\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\"},\"headline\":\"How to Deal with SQL Server 2008 R2 Error 926?\",\"datePublished\":\"2017-09-20T05:29:52+00:00\",\"dateModified\":\"2022-08-03T04:37:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/\"},\"wordCount\":1155,\"commentCount\":9,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg\",\"articleSection\":[\"SQL Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/\",\"name\":\"How to Fix Microsoft SQL Server 2008 R2 Error 926?\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg\",\"datePublished\":\"2017-09-20T05:29:52+00:00\",\"dateModified\":\"2022-08-03T04:37:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\"},\"description\":\"Learn how to fix Microsoft SQL Server 2008 R2 Error 926 manually using step-wise instructions or an automated method explained in this blog.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg\",\"width\":1000,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Deal with SQL Server 2008 R2 Error 926?\"}]},{\"@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\/94fe9ee94eb813d94397deee2b641470\",\"name\":\"Priyanka Chauhan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"caption\":\"Priyanka Chauhan\"},\"description\":\"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/priyankachouhan\/\",\"https:\/\/x.com\/priyanka66\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/priyanka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix Microsoft SQL Server 2008 R2 Error 926?","description":"Learn how to fix Microsoft SQL Server 2008 R2 Error 926 manually using step-wise instructions or an automated method explained in this blog.","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\/fix-sql-server-2008-r2-error-926\/","og_locale":"en_US","og_type":"article","og_title":"How to Fix Microsoft SQL Server 2008 R2 Error 926?","og_description":"Learn how to fix Microsoft SQL Server 2008 R2 Error 926 manually using step-wise instructions or an automated method explained in this blog.","og_url":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2017-09-20T05:29:52+00:00","article_modified_time":"2022-08-03T04:37:34+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg","type":"image\/jpeg"}],"author":"Priyanka Chauhan","twitter_card":"summary_large_image","twitter_creator":"@priyanka66","twitter_misc":{"Written by":"Priyanka Chauhan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/"},"author":{"name":"Priyanka Chauhan","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"headline":"How to Deal with SQL Server 2008 R2 Error 926?","datePublished":"2017-09-20T05:29:52+00:00","dateModified":"2022-08-03T04:37:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/"},"wordCount":1155,"commentCount":9,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg","articleSection":["SQL Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/","url":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/","name":"How to Fix Microsoft SQL Server 2008 R2 Error 926?","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg","datePublished":"2017-09-20T05:29:52+00:00","dateModified":"2022-08-03T04:37:34+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"description":"Learn how to fix Microsoft SQL Server 2008 R2 Error 926 manually using step-wise instructions or an automated method explained in this blog.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/09\/How-to-deal-with-SQL-2008-r2-error-926-database.jpg","width":1000,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/fix-sql-server-2008-r2-error-926\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Deal with SQL Server 2008 R2 Error 926?"}]},{"@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\/94fe9ee94eb813d94397deee2b641470","name":"Priyanka Chauhan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","caption":"Priyanka Chauhan"},"description":"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.","sameAs":["https:\/\/www.linkedin.com\/in\/priyankachouhan\/","https:\/\/x.com\/priyanka66"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/priyanka\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/11157","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\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=11157"}],"version-history":[{"count":31,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/11157\/revisions"}],"predecessor-version":[{"id":106245,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/11157\/revisions\/106245"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/11169"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=11157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=11157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=11157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}