{"id":1298,"date":"2013-05-02T13:05:07","date_gmt":"2013-05-02T13:05:07","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=1298"},"modified":"2014-04-23T09:36:30","modified_gmt":"2014-04-23T09:36:30","slug":"the-file-is-compressed-but-does-not-reside-in-a-read-only-database-or-filegroup-the-file-must-be-decompressed-restore-database-is-terminating-abnormally","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/the-file-is-compressed-but-does-not-reside-in-a-read-only-database-or-filegroup-the-file-must-be-decompressed-restore-database-is-terminating-abnormally\/","title":{"rendered":"The file &#8220;<file.mdf>&#8221; is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally."},"content":{"rendered":"<p><strong>Error:<\/strong><\/p>\n<p>The file &#8220;&lt;file.mdf&gt;&#8221; is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally.<\/p>\n<p><strong><strong>Snapshot<\/strong>:<\/strong><\/p>\n<p><a href=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2013\/05\/2.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1299\" title=\"2\" src=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2013\/05\/2.png\" alt=\"\" width=\"414\" height=\"203\" srcset=\"https:\/\/relyonsoft.in\/techsupport\/wp-content\/uploads\/2013\/05\/2.png 414w, https:\/\/relyonsoft.in\/techsupport\/wp-content\/uploads\/2013\/05\/2-300x147.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\" \/><\/a><\/p>\n<p><strong>Cause:<\/strong><\/p>\n<p>This is because, a read\/write database [.mdf and .ldf] files cannot be created on a compressed drive\/directory. [Compressed directory\/drive is in blue color.]<\/p>\n<p><strong>Solution 1:<\/strong><\/p>\n<p>De-compress the drive\/data directory.<\/p>\n<p>Right click on &#8220;DATA&#8221; directory<\/p>\n<p>Click Advanced<\/p>\n<p>Uncheck &#8220;Compress contents to save disk space&#8221;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: The file &#8220;&lt;file.mdf&gt;&#8221; is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally. Snapshot: Cause: This is because, a read\/write database [.mdf and .ldf] files cannot be created on a compressed drive\/directory. [Compressed directory\/drive is in blue color.] Solution 1: De-compress the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1298"}],"collection":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=1298"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/1298\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=1298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=1298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=1298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}