• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

How to move WSUS database from 1 harddisk to another

I have WSUS running on my 2003 DC. I have 2 physical harddisks on the server. The first drive contains system and user files.  The 2nd drive contains only WSUS database files.  This 2nd drive is now beginning to have bad blocks.  I don't want to replace the 2nd drive.  I just want to have everything on 1 drive. So how can I move the WSUS database files to the 1st drive and change the WSUS settings to access the database files at the new location?

Do I also need to make changes under IIS?

Although I installed the entire system here, I have very limited knowledge about how WSUS and IIS function, so please assume you are speaking to a novice.
2 Solutions
And here's how to do it using sqlcmd instead (I believe sqlcmd has replaced osql):


About half way down there is a section called "Using SQL functions / SQLCMD"...

Any problems, let us know.


Alistair7Author Commented:
My apologies to you Modar and Pete for not responding and allocating points.  Many thanks for your input.  I have followed and read your links, but not had the time to take it further, which I still need to do actually.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now