{"id":1725,"date":"2013-12-13T16:20:11","date_gmt":"2013-12-13T16:20:11","guid":{"rendered":"http:\/\/www.obieta.com\/?p=1725"},"modified":"2013-12-13T16:20:11","modified_gmt":"2013-12-13T16:20:11","slug":"the-log-scan-number-passed-to-log-scan-in-database-master-is-not-valid-this-error-may-indicate-data-corruption-or-that-the-log-file-ldf-does-not-match-the-data-file-mdf-if-th","status":"publish","type":"post","link":"http:\/\/obieta.com\/?p=1725","title":{"rendered":"The log scan number passed to log scan in database \u2018master\u2019 is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup."},"content":{"rendered":"<p>While restarting the MS SQL service you will get an error and MS SQL service on the server wont start . If you check the eventviewer\u00a0 you will get the following\u00a0 event logs<\/p>\n<p>The log scan number passed to log scan in database \u2018master\u2019 is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.<\/p>\n<p>This usually occurs when the master.mdf or the mastlog.ldf gets corrupt . In order to solve the issue goto the following path<\/p>\n<p>C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL\u00a0 , there you will find a\u00a0 folder \u201d Template Data \u201d , copy the master.mdf and\u00a0 mastlog.ldf\u00a0 and replace it in<\/p>\n<p>C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData folder .<\/p>\n<p>Thats it . Now\u00a0 start the MS SQL service and you are done .<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While restarting the MS SQL service you will get an error and MS SQL service on the server wont start . If you check the eventviewer\u00a0 you will get the following\u00a0 event logs The log scan number passed to log scan in database \u2018master\u2019 is not valid. This error may indicate data corruption or that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,8],"tags":[],"_links":{"self":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1725"}],"collection":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1725"}],"version-history":[{"count":0,"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1725\/revisions"}],"wp:attachment":[{"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1725"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}