Solved

How to move WSUS database from 1 harddisk to another

Posted on 2009-05-05
4
526 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
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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

So you have two Windows Servers and you have a directory/folder/files on one that you'd like to mirror to the other?  You don't really want to deal with DFS or a 3rd party solution like Doubletake. You can use Robocopy from the Windows Server 200…
This may not be a text book method to resolve VSS backup issues but it seemed to have worked on few of the Windows 2003 servers we had issues while performing a Volume Shadow Copy backup. If you have issues while performing a shadow copy backup usin…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now