Home arrow News and Blogs arrow Technology arrow WSUS 3 : Relocating WID Thursday, September 09 2010  
Ninja Dulak Logo Ninja
Menu Div HomeMenu Div News and BlogsMenu DivPhoto GalleryMenu DivRecommended LinksMenu Div
Main Menu
Home
News and Blogs
Photo Gallery
Recommended Links
Linkage
Creative Commons License
The above image is licensed under a Creative Commons Attribution-Non Commercial-NoDerivs 2.5 License.
Most favoured


WSUS 3 : Relocating WID
Written by Grant   
Tuesday, 30 September 2008

The other day I had this problem at work ... my WSUS 3 server was running out of disk space. I was due to go on holidays the next day and did not want to worry about my network not being updated while I was gone. So I decided to fix the problem. I began researching moving the Windows Internal Database (which is used to drive a WSUS server when SQL Server is not installed) on a Windows 2003 SP2 server to a separate drive/partition/volume.

I googled for hours on this subject and could not find tthe solution I was after; and here's me thinking that someone might have done this in the past. But it seems that the only solutions out there are ones that are dated in the late ninties (exageration). So I thought that I would post my findings and hopefully help someone out there how is having the same issue. So here it goes ...

  1. download and install the SQL Native Client and SQLCMD pack from here
  2. Stop "Update Servcies" and "World Wide Web Publishing Services"
  3. open a command prompt
  4. change directory to C:\Program Files\Microsoft SQL Server\90\Tools\binn (default location for the sqlcmd install)
  5. type - sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E
  6. type - EXEC sp_detach_db @dbname = 'SUSDB'
  7. type - go
  8. The copy the database to your new location eg e:\WSUSDatabase; which is used in the below example
  9. type - EXEC sp_attach_db @dbname = 'SUSDB', @filename1 = 'E:\WSUSDatabase\SUSDB.mdf', @filename2 = 'E:\WSUSDatabase\SUSDB_log.ldf'
  10. type - go
  11. Start "Update Servcies" and "World Wide Web Publishing Services"
  12. Done.

Hope this helps someone out there on the Intraweb ...

 


Add as favourites (192) | Quote this article on your site | Views: 701

  Be first to comment this article

Write Comment
  • Please keep the topic of messages relevant to the subject of the article.
  • Personal verbal attacks will be deleted.
  • Please don't use comments to plug your web site. Such material will be removed.
  • Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button.
  • Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
E-mail
Homepage
Title:
BBCode:Web AddressEmail AddressBold TextItalic TextUnderlined TextQuoteCodeOpen ListList ItemClose List
Comment:



Code:* Code
I wish to be contacted by email regarding additional comments

Powered by AkoComment Tweaked Special Edition v.1.4.6
AkoComment © Copyright 2004 by Arthur Konze - www.mamboportal.com
All right reserved
 
.:. Dulak.Net .:. Template based on AkoDarkGem by Arthur Konze Top of Page