Solved

How to move WSUS database from 1 harddisk to another

Posted on 2009-05-05
4
532 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:Alistair7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 1

Accepted Solution

by:
Modar_Hijazi earned 250 total points
ID: 24304133
0
 
LVL 19

Assisted Solution

by:PeteJThomas
PeteJThomas earned 250 total points
ID: 24304267
And here's how to do it using sqlcmd instead (I believe sqlcmd has replaced osql):

http://blog.augustoalvarez.com.ar/2009/01/25/wsus-30-connecting-managing-and-moving-susdb-as-internal-database/

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

Any problems, let us know.

Cheers,

Pete
0
 

Author Comment

by:Alistair7
ID: 24950440
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.

thanks

Alistair
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question