Solved

How to move WSUS database from 1 harddisk to another

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

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…
I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…

726 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