{"id":685,"date":"2010-12-27T22:25:00","date_gmt":"2010-12-27T22:25:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/"},"modified":"2010-12-27T22:25:00","modified_gmt":"2010-12-27T22:25:00","slug":"how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/","title":{"rendered":"How to move a SharePoint Content Database to a new physical drive\/location"},"content":{"rendered":"<div class=\"ExternalClassD6FD607918054DD9A3C0C57EEB96AB65\">\n<p>There may come a time when you want to move a SharePoint content database from one disk on your SQL Server to another. Perhaps you installed SharePoint in standalone mode and don&#8217;t like the location it chose or you just need to move some stuff around. The following assumes you are moving the database from one disk to another on the same SQL Server and that you don&#8217;t need to let SharePoint know what is going on (this is happening &#8216;under the hood&#8217;). <\/p>\n<p>\u00a0<\/p>\n<p><span style=\"color:#17365d;font-size:16pt\"><strong>Steps<\/strong> <\/span><\/p>\n<ul style=\"margin-left:54pt\">\n<li>You can never have enough backups, take one, just for good measure <\/li>\n<li>Prune transaction logs, to keep the files (*.ldb) necessary to move, smaller <\/li>\n<li>Stop services that depend on the database (SharePoint, IIS\/Web) <\/li>\n<li>Detach the database(s) <\/li>\n<li>Move the database(s) <strong><em>and their logfiles<\/em><\/strong> <\/li>\n<li>Attach the database(s) <\/li>\n<li>Bring the services back online <\/li>\n<li>Test\/validate all is well <\/li>\n<\/ul>\n<p>\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><span style=\"color:#17365d;font-size:16pt\"><strong>Stop All SharePoint Related Services<\/strong> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS1.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS2.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<ul style=\"margin-left:45pt\">\n<li>IIS Admin Service (and likely SMTP as a dependency)<span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/li>\n<li>All SharePoint Services <\/li>\n<li>World Wide Web Publishing Service <\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><span style=\"color:#17365d;font-size:16pt\"><strong>Detach the Database(s) you intend to move<\/strong> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS3.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS4.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><span style=\"color:#17365d;font-size:16pt\"><strong>Move the Databases and their Logfiles<\/strong> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS5.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS6.png\"> <\/p>\n<p><span style=\"color:#4f81bd\"><strong><span style=\"font-size:9pt\">Figure 1: This step takes as long as it takes&#8230; plan accordingly for size vs time<\/span><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/strong><\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><span style=\"color:#17365d;font-size:16pt\"><strong>Reattach the Databases<\/strong> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS7.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS8.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS9.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><img decoding=\"async\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/122810_0620_HowtomoveaS10.png\"><span style=\"font-family:Times New Roman;font-size:12pt\"> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><span style=\"color:#17365d;font-size:16pt\"><strong>Restart all Stopped Services<\/strong> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\">Start the services you stopped earlier <\/p>\n<p style=\"margin-left:18pt\">\u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\"><span style=\"color:#17365d;font-size:16pt\"><strong>Test<\/strong> <\/span><\/p>\n<p style=\"margin-left:18pt\">\u00a0 \u00a0<\/p>\n<p style=\"margin-left:18pt\">Make sure it works, eh? Check logs, etc. <\/p>\n<p style=\"margin-left:18pt\">\u00a0<\/p>\n<p style=\"margin-left:18pt\">\u00a0<\/p>\n<p style=\"margin-left:18pt\">That&#8217;s it. Easy Peasy. <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>There may come a time when you want to move a SharePoint content database from one disk on your SQL Server to another. Perhaps you installed SharePoint in standalone mode and don&#8217;t like the location it chose or you just need to move some stuff around. The following assumes you are moving the database from &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[337,14,334,428,339],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to move a SharePoint Content Database to a new physical drive\/location - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to move a SharePoint Content Database to a new physical drive\/location - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"There may come a time when you want to move a SharePoint content database from one disk on your SQL Server to another. Perhaps you installed SharePoint in standalone mode and don&#8217;t like the location it chose or you just need to move some stuff around. The following assumes you are moving the database from &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-27T22:25:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/\",\"name\":\"How to move a SharePoint Content Database to a new physical drive\/location - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2010-12-27T22:25:00+00:00\",\"dateModified\":\"2010-12-27T22:25:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to move a SharePoint Content Database to a new physical drive\/location\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to move a SharePoint Content Database to a new physical drive\/location - Brainlitter - Inside the mind of Sean Wallbridge","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:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/","og_locale":"en_US","og_type":"article","og_title":"How to move a SharePoint Content Database to a new physical drive\/location - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"There may come a time when you want to move a SharePoint content database from one disk on your SQL Server to another. Perhaps you installed SharePoint in standalone mode and don&#8217;t like the location it chose or you just need to move some stuff around. The following assumes you are moving the database from &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2010-12-27T22:25:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/","url":"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/","name":"How to move a SharePoint Content Database to a new physical drive\/location - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2010-12-27T22:25:00+00:00","dateModified":"2010-12-27T22:25:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2010\/12\/27\/how-to-move-a-sharepoint-content-database-to-a-new-physical-drive-location\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"How to move a SharePoint Content Database to a new physical drive\/location"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/685"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=685"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}