{"id":1062,"date":"2018-11-01T06:40:26","date_gmt":"2018-11-01T06:40:26","guid":{"rendered":"https:\/\/www.filerepairtools.com\/tips\/?p=1062"},"modified":"2018-11-01T06:40:26","modified_gmt":"2018-11-01T06:40:26","slug":"resolving-sql-database-error-5243-5242","status":"publish","type":"post","link":"https:\/\/filerepairtools.com\/tips\/resolving-sql-database-error-5243-5242\/","title":{"rendered":"Resolving SQL Database Error 5243 and 5242"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">A database is the most vital platform for any application. The database contains the record of each and entry made by the user, it consists of tables, indexes, queries, searches, and all items that are accessed by a user. SQL Database is the most preferred one and Database Administrator (DBA) used it on many platforms. SQL is also prone to errors and sometimes DBA encounters SQL Database restore error 5243 and 5242.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Most of the Database Administrators get an error message:<\/span><\/p>\n<p>Msg 5242, Level 22, State 1, Line 1<\/p>\n<p>An inconsistency was detected during an internal operation in database \u2018Invoices'(ID:11) on the page (1:35393). Please contact the technical support. Reference number 4.<\/p>\n<p><span style=\"font-weight: 400;\">This message code directly denotes the SQL restore error. Errors in the database cannot be accepted and hence should be resolved quickly. Here are some methods to fix SQL database 5243 and 5242 error. These errors can be resolved by<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Manual Method: Using the DBCC CHECKDB Transact SQL command or try to restore database SQL server page<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Automatic Method: Using SQL Database Recovery tool<\/span><\/li>\n<\/ul>\n<p><b>Prerequisites<\/b><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Before going for manual method, users should have the following setup<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">First, you should have SQL server installed <\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Users should have installed SQL Server Management Studio<\/span><\/li>\n<\/ul>\n<h2><b>Manual Methods to Fix Error Message 5242 and 5243<\/b><\/h2>\n<p><b>Restore Database from SQL Server Page<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The SQL database can be restored from the SQL server page. The error 5242 and 5243 may be a result of the corrupt page<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can view the corrupt SQL server page by using Select MSDB database in the suspect_pages table. If any page is corrupt then it will be found in the suspect_pages table. You can use T-SQL command to restore the database and avoid 5243 error<\/span><\/p>\n<p><span style=\"font-weight: 400;\">RESTORE DATABASE &lt;database_name&gt;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">PAGE=file: page<\/span><\/p>\n<p><span style=\"font-weight: 400;\">FROM &lt;device_name&gt;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">WITH NORECOVERY<\/span><\/p>\n<p><b>Use DBCC CHECKDB Command<\/b><\/p>\n<p><span style=\"font-weight: 400;\">DBCC CHECKDB command helps in knowing the logical and physical integrity of the database. Run the T-SQL command DBCC CHECKDB to know the status of the database and if any problem is found you can repair it with the REPAIR_REBUILD option.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can also go for SQL Server Management Studio and check the errors. Perform the application based command from SSMS to repair and restore the database.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The manual methods are complex and those not familiar with SQL DB commands should not go for it. Try the SQL Recovery Tool to repair and recover the database.<\/span><\/p>\n<p><b>SQL Recovery Tool Features<\/b><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The Tool can repair both MDF and NDF Files<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">It includes recovery of SQL tables, indexes, Keys and other defaults<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Recover deleted records and save in Multiple formats<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">User-friendly interface<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Search files and repair them individually instead of full recovery<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The database is compatible to work with SQL Server 2016\/ 2014\/ 2012\/ 2008 \/2005 and other previous versions.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Thus, you can go for <a href=\"https:\/\/www.filerepairtools.com\/sql-database-repair.html\">SQL Database recovery tool<\/a> to repair and recover database files efficiently.\u00a0<\/span><\/p>\n<hr \/>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.filerepairtools.com\/recommends\/sql-repair\/download.html\" target=\"_blank\" rel=\"nofollow noopener sponsored noreferrer\"><strong>Download the SQL Repair tool from here\u00a0<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18\" src=\"https:\/\/www.filerepairtools.com\/tips\/wp-content\/uploads\/2017\/06\/download.png\" alt=\"\" width=\"222\" height=\"60\" \/>Use Code FRT2020 for 20% Off<\/a><\/p>\n<hr \/>\n<p style=\"text-align: center;\">\n","protected":false},"excerpt":{"rendered":"<p>A database is the most vital platform for any application. The database contains the record of each and entry made by the user, it consists of tables, indexes, queries, searches, and all items that are accessed by a user. SQL Database is the most preferred one and Database Administrator (DBA) used it on many platforms. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2219,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1062","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-repair"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts\/1062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/comments?post=1062"}],"version-history":[{"count":0,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/posts\/1062\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/media?parent=1062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/categories?post=1062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/filerepairtools.com\/tips\/wp-json\/wp\/v2\/tags?post=1062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}