{"id":1846,"date":"2017-01-13T19:05:18","date_gmt":"2017-01-13T19:05:18","guid":{"rendered":"http:\/\/www.obieta.com\/?p=1846"},"modified":"2017-01-13T19:05:18","modified_gmt":"2017-01-13T19:05:18","slug":"how-do-i-move-sql-server-database-files","status":"publish","type":"post","link":"http:\/\/obieta.com\/?p=1846","title":{"rendered":"How do I move SQL Server database files"},"content":{"rendered":"<p>you don&#8217;t mind stop the database from working, then you can <code>DETACH<\/code> it, move the files and then <code>ATTACH<\/code> it.<\/p>\n<ul>\n<li>Right click on the name of the database<\/li>\n<li>Select <code>Properties<\/code><\/li>\n<li>Go to the <code>Files<\/code> tab<\/li>\n<li><strong>Make a note of the <code>Path<\/code> and <code>FileName<\/code> of MDF and LDF files<\/strong>. This step is important in case you don&#8217;t want to end up searching for missing files&#8230;<\/li>\n<li>Right click on the database name<\/li>\n<li>Select <code>Tasks -&gt; Detach<\/code><\/li>\n<li>Move the files where you want<\/li>\n<li>Right click on the <code>Databases<\/code> node of your server<\/li>\n<li>Select <code>Attach<\/code><\/li>\n<li>Click on the <code>Add<\/code> button<\/li>\n<li>Point to the new location<\/li>\n<li>Click <code>OK<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>you don&#8217;t mind stop the database from working, then you can DETACH it, move the files and then ATTACH it. Right click on the name of the database Select Properties Go to the Files tab Make a note of the Path and FileName of MDF and LDF files. This step is important in case you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1846"}],"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=1846"}],"version-history":[{"count":0,"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1846\/revisions"}],"wp:attachment":[{"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1846"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}