Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to move WSUS database from 1 harddisk to another

Posted on 2009-05-05
4
Medium Priority
?
535 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 1000 total points
ID: 24304133
0
 
LVL 19

Assisted Solution

by:PeteJThomas
PeteJThomas earned 1000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

604 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