{"id":85,"date":"2010-07-25T01:01:54","date_gmt":"2010-07-25T01:01:54","guid":{"rendered":"http:\/\/www.itcrumbs.com\/?p=85"},"modified":"2019-02-07T04:40:47","modified_gmt":"2019-02-07T04:40:47","slug":"how-to-move-wsus-content-and-database-files-to-a-different-volume","status":"publish","type":"post","link":"https:\/\/www.itcrumbs.com\/?p=85","title":{"rendered":"How to Move WSUS Content and Database Files to a Different Volume"},"content":{"rendered":"<p><a title=\"http:\/\/blogs.technet.com\/b\/sbs\/archive\/2009\/09\/23\/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx\" href=\"http:\/\/blogs.technet.com\/b\/sbs\/archive\/2009\/09\/23\/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx\">http:\/\/blogs.technet.com\/b\/sbs\/archive\/2009\/09\/23\/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx<\/a><\/p>\n<h5>How to Move WSUS Content and Database Files to a Different Volume<\/h5>\n<p><a href=\"http:\/\/blogs.technet.com\/members\/SBS-Bloggers\/\"><img decoding=\"async\" alt=\"\" src=\"http:\/\/blogs.technet.com\/utility\/anonymous.gif\" \/><\/a> <a href=\"http:\/\/blogs.technet.com\/members\/SBS-Bloggers\/\">SBS Bloggers<\/a><\/p>\n<p>23 Sep 2009 4:38 PM <\/p>\n<ul>\n<li>Comments <a href=\"http:\/\/blogs.technet.com\/b\/sbs\/archive\/2009\/09\/23\/#comments\">2<\/a><\/li>\n<\/ul>\n<p><em>[Today&#8217;s post<\/em> <em>comes to us courtesy of Rod White]<\/em><\/p>\n<p>When trying to free up space, customers frequently have questions about moving WSUS Content and Databases to different partitions. Our objective is to explain three things:<\/p>\n<ul>\n<li>How to move the WSUS Content <\/li>\n<li>How to move the WSUS Database files <\/li>\n<li>How to cleanup the WSUS Database <\/li>\n<\/ul>\n<p>Start by checking the size of the Volumes by looking at the Server Storage. Open <b>SBS Console<\/b> and select the <b>Backup and Server Storage <\/b>Tab. Next, select <b>Server Storage<\/b> to determine the space available on each partition. When highlighting the C: drive you&#8217;ll see the size of the different components that you may wish to move with the Storage Wizards. Today we will focus on moving the WSUS Components. Under the Storage Task the <b>Move Windows Update Repository Data<\/b> Wizard only moves the downloaded content. This will not move the WSUS Metadata or SUS database (SUSDB.mdf and SUSDB.ldf).<\/p>\n<p><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image002_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image002\" border=\"0\" alt=\"clip_image002\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image002_thumb.jpg\" width=\"526\" height=\"383\" \/><\/a><\/p>\n<h5>How to Move the WSUS Content<\/h5>\n<ol>\n<li>Open the SBS console and select <b>Backup and Server Storage<\/b>. <\/li>\n<li>Select the <b>Server Storage<\/b> tab. <\/li>\n<li>Click the <b>Move Windows Update Repository Data<\/b> Wizard. <\/li>\n<li>When prompted to take a backup, we recommend that you select <b>Yes<\/b>. <\/li>\n<li>Select the new drive location and click <b>Move.<\/b><\/li>\n<\/ol>\n<p>During the move the wizard will create a WSUS directory on the new location and will begin copying the contents into the &lt;Drive&gt;:\\WSUS\\WsusContent directory.<\/p>\n<h5>How to Move the WSUS Database <\/h5>\n<ol>\n<li>Launch SQL Server Management Studio Express console as an administrator. It is located under <b>Start<\/b> &gt; <b>Programs<\/b> &gt; <b>Microsoft SQL Server 2005<\/b> &gt; <b>SQL Server Management Studio Express.        <br \/><\/b><\/li>\n<li>Fill in the following information and then click Connect\n<ul>\n<li>Server type: Database Engine <\/li>\n<li>Servername: \\\\.\\pipe\\MSSQL$MICROSOFT##SSEE\\sql\\query <\/li>\n<li>Authentication: Windows Authentication          <br \/><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image004_2.gif\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image004\" border=\"0\" alt=\"clip_image004\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image004_thumb.gif\" width=\"258\" height=\"192\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>Expand <b>Databases<\/b> and right-click on <b>SUSDB<\/b> and select <b>Tasks<\/b> &gt; <b>Detach&#8230; <\/b>from the context menu.       <br \/><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image006_2.gif\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image006\" border=\"0\" alt=\"clip_image006\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image006_thumb.gif\" width=\"434\" height=\"264\" \/><\/a><b><\/b><\/li>\n<li>Select the &quot;<b>Drop Connection<\/b>&quot; checkbox and click <b>OK.        <br \/><b><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image008_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image008\" border=\"0\" alt=\"clip_image008\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image008_thumb.jpg\" width=\"451\" height=\"100\" \/><\/a><\/b><\/b><\/li>\n<li>Open explorer and move the C:\\WSUS\\SUSDB folder to the &lt;new drive&gt;:\\WSUS directory. <\/li>\n<li>To reattach the database, right-click on Database and select <b>Attach<\/b>\u2026 from the context menu.       <br \/><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image010_2.gif\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image010\" border=\"0\" alt=\"clip_image010\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image010_thumb.gif\" width=\"434\" height=\"266\" \/><\/a><\/li>\n<li>On the Attach Databases page select the <b>Add<\/b> button.       <br \/><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image012_2.jpg\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image012\" border=\"0\" alt=\"clip_image012\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image012_thumb.jpg\" width=\"446\" height=\"210\" \/><\/a><\/li>\n<li>Browse to the new location of the SUSDB.mdf database and select <b>OK<\/b> twice to complete the move. <a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image014_2.gif\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image014\" border=\"0\" alt=\"clip_image014\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image014_thumb.gif\" width=\"267\" height=\"379\" \/><\/a><\/li>\n<\/ol>\n<h5>How to Cleanup the WSUS Database<\/h5>\n<p><b>Note: <\/b>We recommend you perform these steps after hours due to significant resource requirements.<\/p>\n<ol>\n<li>Open the native WSUS console. <b>Start<\/b> &gt; <b>Programs<\/b> &gt; <b>Administrative<\/b> <b>Tools<\/b> &gt; <b>Microsoft Windows server Update Services 3.0 SP1<\/b>. <\/li>\n<li>Expand your server and select<b> Options<\/b> &gt; <b>Server Cleanup Wizard<\/b>.       <br \/><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image016_2.gif\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image016\" border=\"0\" alt=\"clip_image016\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image016_thumb.gif\" width=\"413\" height=\"365\" \/><\/a><\/li>\n<li>Leave all boxes checked and click <b>Next <\/b>to start the cleaning process.       <br \/><a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image018_2.gif\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image018\" border=\"0\" alt=\"clip_image018\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image018_thumb.gif\" width=\"364\" height=\"132\" \/><\/a>      <br \/><b>Note: <\/b>This process may take many hours to complete (24+ in some cases). <\/li>\n<li>Once the scan has completed it will display the summary information as shown below. The key information is the <b>Disk space freed by deleting unused content files<\/b>. Click <b>Finish<\/b> to complete the wizard.<a href=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image020_2.gif\"><img loading=\"lazy\" decoding=\"async\" title=\"clip_image020\" border=\"0\" alt=\"clip_image020\" src=\"http:\/\/blogs.technet.com\/blogfiles\/sbs\/WindowsLiveWriter\/HowtoMoveWSUSContentandDatabaseFilestoaD_DBE5\/clip_image020_thumb.gif\" width=\"438\" height=\"387\" \/><\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/blogs.technet.com\/b\/sbs\/archive\/2009\/09\/23\/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx How to Move WSUS Content and Database Files to a Different Volume SBS Bloggers 23 Sep 2009 4:38 PM Comments 2 [Today&#8217;s post comes to us courtesy of Rod White] When trying to free up space, customers frequently have questions about moving WSUS Content and Databases to different partitions. Our objective is to explain [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-85","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/85","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=85"}],"version-history":[{"count":1,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/85\/revisions"}],"predecessor-version":[{"id":817,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/85\/revisions\/817"}],"wp:attachment":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}