{"id":9141,"date":"2017-08-04T10:59:49","date_gmt":"2017-08-04T10:59:49","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=9141"},"modified":"2024-01-24T08:47:18","modified_gmt":"2024-01-24T08:47:18","slug":"sql-server-2008-r2-database-error-5123","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/","title":{"rendered":"How to Fix SQL Server 2008 R2 Database Error 5123"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>The &lsquo;SQL Server error: 5123, severity 16, state 1&rsquo; occurs when attaching database in SQL Server 2008 R2 or higher versions. This may happen when the database you&rsquo;re trying to attach is placed in a different location.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"228\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/05\/SQL-database-error-5123.png\" alt=\"SQL Server error: 5123\" class=\"wp-image-39701 apply-gradient-on-post-images\" style=\"width:650px;height:228px\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/05\/SQL-database-error-5123.png 650w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/05\/SQL-database-error-5123-300x105.png 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption class=\"wp-element-caption\">Figure 1 &ndash; SQL database error 5123<\/figcaption><\/figure>\n<\/div><p>Reading the complete error message &ldquo;<em><strong>CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file&hellip;<\/strong>&rdquo; <\/em>clearly indicates that it occurs due to a permission issue.<\/p><p>Now let&rsquo;s discuss in detail the possible reasons leading to SQL Server error 5123.<\/p><h2 class=\"wp-block-heading\" id=\"reasons-behind-microsoft-sql-server-error-5123\"><strong>Reasons Behind Microsoft SQL Server Error 5123<\/strong><\/h2><p>You may receive the error due to any of these reasons: <\/p><ul class=\"wp-block-list\">\n<li>When you try to attach a database, which is placed on different locations, and do not have sufficient privileges to the&nbsp;<strong>folder directory. <\/strong><strong><\/strong><\/li>\n<\/ul><ul class=\"wp-block-list\">\n<li>Alternatively, this error can also occur when different logins are involved in attaching and&nbsp;detaching the database. For instance, the Windows login used to detach the db is different from the Windows login used for reattaching the db.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"how-to-resolve-sql-server-2008-r2-database-error-5123?\"><strong>How to Resolve SQL Server 2008 R2 Database Error 5123?<\/strong><strong><\/strong><\/h2><p>To resolve this issue, you will need to change or add permissions as the owner of the&nbsp;MDF and LDF files. To do so, follow these steps:<\/p><h3 class=\"wp-block-heading\" id=\"h-step-1-grant-full-permissions-on-database-files\"><strong>Step 1: Grant Full Permissions on Database Files<\/strong><\/h3><ul class=\"wp-block-list\">\n<li>Right-click on the database file xxxx.mdf reported in the error message, and then select <strong>Properties<\/strong>.<\/li>\n\n\n\n<li>Check the permissions of the MDF file by clicking the <strong>Security<\/strong> tab. The system displays a list of user accounts under <strong>Group or user names.<\/strong><\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/MDF-file-properties.jpg\" alt=\"Select Security in SQL Database Properties Window\"><figcaption class=\"wp-element-caption\">Figure 2 &ndash; Select Security in SQL Database Properties Window<\/figcaption><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>On the &lsquo;xxxx.mdf security properties&rsquo; window, click <strong>Add<\/strong>. Add the user credentials for User2, and check the <strong>Full Control<\/strong> checkbox under <strong>Allow<\/strong>. Click <strong>OK<\/strong>.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Add-another-user-768x423.jpg\" alt=\"Select Full Control Permission\"><figcaption class=\"wp-element-caption\">Figure 3 &ndash; Select Full Control Permission<\/figcaption><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Try to attach the file to the database using the same credentials used to detach the database.<\/li>\n<\/ul><h3 class=\"wp-block-heading\" id=\"h-step-2-attach-the-sql-database\"><strong>Step 2 <\/strong><strong>&ndash;<\/strong><strong> Attach the SQL Database<\/strong><\/h3><p>Try attaching the database in SQL Server using any of the following methods:<\/p><h4 class=\"wp-block-heading\" id=\"h-method-1-using-sql-server-management-studio-ssms\"><strong>Method 1: Using SQL Server Management Studio (SSMS<u>)<\/u><\/strong><\/h4><ul class=\"wp-block-list\">\n<li>Using SSMS or the new SQL Operations Studio tool, connect to your valid server&rsquo;s name with either Windows or SQL Authentication.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Connect-to-Server.jpg\" alt=\"Connect to SQL Server Instance\"><figcaption class=\"wp-element-caption\">Figure 4 &ndash; Connect to SQL Server Instance<\/figcaption><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>Go to the Object Explorer and click on &lsquo;<strong>Databases<\/strong>&rsquo; to see a list of existing databases. Right-click on the <strong>&lsquo;Database&rsquo;<\/strong> and select &lsquo;<strong>Attach<\/strong>&rsquo; from the drop-down menu.<\/li>\n\n\n\n<li>When an <strong>&lsquo;Attach Databases&rsquo;<\/strong> window opens, click on the &lsquo;<strong>Add<\/strong>&rsquo; button. In the dialog box that appears, select the database you want to attach, and then click &lsquo;<strong>OK<\/strong>&rsquo;.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Select-MDF-file.jpg\" alt=\"Select Database To Attach in SQL Server\"><figcaption class=\"wp-element-caption\">Figure 5 &ndash; Select Database To Attach in SQL Server<\/figcaption><\/figure>\n<\/div><ul class=\"wp-block-list\">\n<li>The database window will confirm the MDF and LDF files. Now, click &lsquo;<strong>OK.<\/strong>&rsquo; The database files should successfully attach to the SQL Server instance as long as the database&rsquo;s logical name does not exist on the instance.<\/li>\n<\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/Attach-Database.jpg\" alt=\"attach database\"><figcaption class=\"wp-element-caption\">Figure 6: attach database<\/figcaption><\/figure>\n<\/div><h4 class=\"wp-block-heading\" id=\"h-method-2-using-t-sql\"><strong><u>Method 2 &ndash; <\/u><\/strong><strong><u>Using T-SQL<\/u><\/strong><\/h4><p>Attach your SQL database using <strong>sp_attach_db stored procedure (deprecated):<\/strong><\/p><figure class=\"wp-block-table\"><table><tbody><tr><td>sp_attach_db[@dbname=] &lsquo;dbname&rsquo;,[@filename1=] &lsquo;filename_n&rsquo; [ ,&hellip;16 ][@dbname=] &ndash; Refers to the name of the database to be attached to the&nbsp;&nbsp; server.[@filename1=] &ndash; &lsquo;filename_n&rsquo; Is the physical name, including path, of a database file\/\/SAMPLE:EXEC sp_attach_db@dbname = N&rsquo;MyDatabase&rsquo;,@filename1 = N&rsquo;D:\\DataFiles\\MyDatabase_Data.mdf&rsquo;,@filename2 = N&rsquo;E:\\LogFiles\\MyDatabase_Log.ldf&rsquo;;<\/td><\/tr><\/tbody><\/table><\/figure><blockquote class=\"note_alert\">\n<p><strong>Note:<\/strong>&nbsp;Update correct path values in the above command as per your system settings.<\/p>\n<\/blockquote><p>After executing the above steps, you won&rsquo;t experience any issue when trying to attach database failed for SQL Server 2008 R2. You can see the attached databases in SQL instance.<\/p><h2 class=\"wp-block-heading\" id=\"what-if-the-error-persists?\"><strong>What if the Error Persists?<\/strong><strong><\/strong><\/h2><p>If the above solution failed to fix the error, that might be an indication that there is a problem within your SQL database. In such a case, you&rsquo;ll need to repair the SQL database to overcome the error try&nbsp;<strong>Stellar Repair for MS SQL.<\/strong>&nbsp;This <a href=\"https:\/\/www.stellarinfo.com\/sql-recovery.php\" target=\"_blank\" rel=\"noreferrer noopener\">SQL recovery software<\/a> is purpose-built to fix all types of corruption errors of SQL Server database. It also helps recover inaccessible objects from MDF and NDF database files. The software repairs a database file while preserving its integrity.<a href=\"https:\/\/cloud.stellarinfo.com\/StellarRepairforMSSQL-Blog.exe\"><\/a><\/p><h2 class=\"wp-block-heading\" id=\"end-note\"><strong>End Note<\/strong><strong><\/strong><\/h2><p>Though <a href=\"https:\/\/www.stellarinfo.com\/sql-database-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">SQL database repair software<\/a> should succeed in resolving the error, in the rare event if it fails, contact Microsoft customer support for professional assistance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The &lsquo;SQL Server error: 5123, severity 16, state 1&rsquo; occurs when attaching&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/\">Continue reading <span class=\"screen-reader-text\">How to Fix SQL Server 2008 R2 Database Error 5123<\/span><\/a><\/p>\n","protected":false},"author":29,"featured_media":9175,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[772,637],"class_list":["post-9141","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-recovery","tag-sql-database-error-5123","tag-sql-server-2008-r2-database-error-5123","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 SQL Server 2008 R2 Database Error 5123?<\/title>\n<meta name=\"description\" content=\"SQL Server 2008 R2 Database Error 5123 is easy to handle with these simple tricks. Read the complete information and save your important database.\" \/>\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\/sql-server-2008-r2-database-error-5123\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix SQL Server 2008 R2 Database Error 5123?\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2008 R2 Database Error 5123 is easy to handle with these simple tricks. Read the complete information and save your important database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-04T10:59:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-24T08:47:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.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=\"Samuel Okudjeto (SQL Server DBA)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Samuel Okudjeto (SQL Server DBA)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/\"},\"author\":{\"name\":\"Samuel Okudjeto (SQL Server DBA)\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/f4cd9d1104638fc38217ed0d861ecaca\"},\"headline\":\"How to Fix SQL Server 2008 R2 Database Error 5123\",\"datePublished\":\"2017-08-04T10:59:49+00:00\",\"dateModified\":\"2024-01-24T08:47:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/\"},\"wordCount\":711,\"commentCount\":7,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg\",\"keywords\":[\"SQL database error 5123\",\"SQL Server 2008 R2 Database Error 5123\"],\"articleSection\":[\"SQL Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/\",\"name\":\"How to Fix SQL Server 2008 R2 Database Error 5123?\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg\",\"datePublished\":\"2017-08-04T10:59:49+00:00\",\"dateModified\":\"2024-01-24T08:47:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/f4cd9d1104638fc38217ed0d861ecaca\"},\"description\":\"SQL Server 2008 R2 Database Error 5123 is easy to handle with these simple tricks. Read the complete information and save your important database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg\",\"width\":1000,\"height\":600,\"caption\":\"SQL error 5123\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Fix SQL Server 2008 R2 Database Error 5123\"}]},{\"@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\/f4cd9d1104638fc38217ed0d861ecaca\",\"name\":\"Samuel Okudjeto (SQL Server DBA)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/264966bb6e87d5b19175805eb97429287cfff90336bfa7465777aa95e68ebc3c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/264966bb6e87d5b19175805eb97429287cfff90336bfa7465777aa95e68ebc3c?s=96&d=mm&r=g\",\"caption\":\"Samuel Okudjeto (SQL Server DBA)\"},\"description\":\"Samuel Okudjeto is a technology enthusiast with great interest in database administration and analytics. He has many certifications including the Microsoft Certified Expert Professional. Along with 6+ years of hands-on experience, he holds a Masters of Science degree in Business Analytics. Read more\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/samuel-okudjeto-865122118\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/samuel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix SQL Server 2008 R2 Database Error 5123?","description":"SQL Server 2008 R2 Database Error 5123 is easy to handle with these simple tricks. Read the complete information and save your important database.","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\/sql-server-2008-r2-database-error-5123\/","og_locale":"en_US","og_type":"article","og_title":"How to Fix SQL Server 2008 R2 Database Error 5123?","og_description":"SQL Server 2008 R2 Database Error 5123 is easy to handle with these simple tricks. Read the complete information and save your important database.","og_url":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2017-08-04T10:59:49+00:00","article_modified_time":"2024-01-24T08:47:18+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg","type":"image\/jpeg"}],"author":"Samuel Okudjeto (SQL Server DBA)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Samuel Okudjeto (SQL Server DBA)","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/"},"author":{"name":"Samuel Okudjeto (SQL Server DBA)","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/f4cd9d1104638fc38217ed0d861ecaca"},"headline":"How to Fix SQL Server 2008 R2 Database Error 5123","datePublished":"2017-08-04T10:59:49+00:00","dateModified":"2024-01-24T08:47:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/"},"wordCount":711,"commentCount":7,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg","keywords":["SQL database error 5123","SQL Server 2008 R2 Database Error 5123"],"articleSection":["SQL Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/","url":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/","name":"How to Fix SQL Server 2008 R2 Database Error 5123?","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg","datePublished":"2017-08-04T10:59:49+00:00","dateModified":"2024-01-24T08:47:18+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/f4cd9d1104638fc38217ed0d861ecaca"},"description":"SQL Server 2008 R2 Database Error 5123 is easy to handle with these simple tricks. Read the complete information and save your important database.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2017\/08\/How-to-fix-sql-server-2008-r2-database-error-5123.jpg","width":1000,"height":600,"caption":"SQL error 5123"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/sql-server-2008-r2-database-error-5123\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Fix SQL Server 2008 R2 Database Error 5123"}]},{"@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\/f4cd9d1104638fc38217ed0d861ecaca","name":"Samuel Okudjeto (SQL Server DBA)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/264966bb6e87d5b19175805eb97429287cfff90336bfa7465777aa95e68ebc3c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/264966bb6e87d5b19175805eb97429287cfff90336bfa7465777aa95e68ebc3c?s=96&d=mm&r=g","caption":"Samuel Okudjeto (SQL Server DBA)"},"description":"Samuel Okudjeto is a technology enthusiast with great interest in database administration and analytics. He has many certifications including the Microsoft Certified Expert Professional. Along with 6+ years of hands-on experience, he holds a Masters of Science degree in Business Analytics. Read more","sameAs":["https:\/\/www.linkedin.com\/in\/samuel-okudjeto-865122118\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/samuel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/9141","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\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=9141"}],"version-history":[{"count":34,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/9141\/revisions"}],"predecessor-version":[{"id":160808,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/9141\/revisions\/160808"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/9175"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=9141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=9141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=9141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}