Move WSUS 3.0 Database from Drive C: to Drive W:

Hello everyone...

I have an SBS 2003 R2 Server that has been upgraded from WSUS 2.0 to 3.0
SP2.

I need to move the 3.5gb database from Drive C to Drive W:. I can't find
any documentation on how to move the database. I did fine info on how to
move the content but not the database.

Can anyone guide me step by step line by line on how to move the database
from one drive to another on the same Server?

Thanks in advance...

--
Bikini Browser of San Juan Puerto Rico
Small Business Office Automation
Small Business Document Imaging Solutions
Networking Solutions using Linksys & Cisco Products
http://www.daleallen.com

(787) 637-9100
www.daleallen.com

The database shouldn't be too big so why bother?

A google of "wsus3 move database" gave me:

http://duitwithsbs.wordpress.com/200...e-and-content/

--
Allan Williams




Bikini Browser wrote:
> Hello everyone...
>
> I have an SBS 2003 R2 Server that has been upgraded from WSUS 2.0 to
> 3.0 SP2.
>
> I need to move the 3.5gb database from Drive C to Drive W:. I can't
> find any documentation on how to move the database. I did fine info
> on how to move the content but not the database.
>
> Can anyone guide me step by step line by line on how to move the
> database from one drive to another on the same Server?
>
> Thanks in advance...

Actually, reading again, your database is 3.5GB? That seems big and it
doesn't seem the cleanup wizard touches the DB (I just tried it on my 1.5GB
database). Moving it may be best but I wonder if it can be shrunk as well?

--
Allan Williams




Al Williams wrote:
> The database shouldn't be too big so why bother?
>
> A google of "wsus3 move database" gave me:
>
> http://duitwithsbs.wordpress.com/200...e-and-content/
>
>
> Bikini Browser wrote:
>> Hello everyone...
>>
>> I have an SBS 2003 R2 Server that has been upgraded from WSUS 2.0 to
>> 3.0 SP2.
>>
>> I need to move the 3.5gb database from Drive C to Drive W:. I can't
>> find any documentation on how to move the database. I did fine info
>> on how to move the content but not the database.
>>
>> Can anyone guide me step by step line by line on how to move the
>> database from one drive to another on the same Server?
>>
>> Thanks in advance...

That artical is a but to techie for me. I found this on the web...

1: net stop "update services"
2: net stop w3svc
3: osql -E -S %computername%\wsusdatabase -Q "exec sp_detach_db 'SUSDB'"
4: md W:\WSUS\MSSQL$WSUS\data
5: move "C:\WSUS\MSSQL$WSUS\Data\SUS*.*" W:\WSUS\MSSQL$WSUS\data
6: osql -E -S %computername%\wsus -Q "exec sp_attach_db @dbname=N'SUSDB',
7: @filename1=N'w:\WSUS\MSSQL$WSUS\data\SUSDB.mdf',
8: @filename2=N'w:\WSUS\MSSQL$WSUS\data\SUSDB_log.ldf '"
9: net start "update services"
10: net start w3svc


the problem is when I get to line 3, I get the following error...

[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect()).

Any ideas on what causes this error? Should the above routine work? Please
advise...

Bikini Browser





"Al Williams" <> wrote in message
news:OKr$...
> The database shouldn't be too big so why bother?
>
> A google of "wsus3 move database" gave me:
>
> http://duitwithsbs.wordpress.com/200...e-and-content/
>
> --
> Allan Williams
>
>
>
>
> Bikini Browser wrote:
>> Hello everyone...
>>
>> I have an SBS 2003 R2 Server that has been upgraded from WSUS 2.0 to
>> 3.0 SP2.
>>
>> I need to move the 3.5gb database from Drive C to Drive W:. I can't
>> find any documentation on how to move the database. I did fine info
>> on how to move the content but not the database.
>>
>> Can anyone guide me step by step line by line on how to move the
>> database from one drive to another on the same Server?
>>
>> Thanks in advance...
>
>

Folks:

I solved the problem myself... I found this link on the web and it was 100%
perfect...

http://blog.augustoalvarez.com.ar/20...rnal-database/

The instructions are easy to follow and the process is really easy.... It
just takes time to download the software from Microsoft.

Bikini Browser


"Al Williams" <> wrote in message
news:...
> Actually, reading again, your database is 3.5GB? That seems big and it
> doesn't seem the cleanup wizard touches the DB (I just tried it on my
> 1.5GB database). Moving it may be best but I wonder if it can be shrunk
> as well?
>
> --
> Allan Williams
>
>
>
>
> Al Williams wrote:
>> The database shouldn't be too big so why bother?
>>
>> A google of "wsus3 move database" gave me:
>>
>> http://duitwithsbs.wordpress.com/200...e-and-content/
>>
>>
>> Bikini Browser wrote:
>>> Hello everyone...
>>>
>>> I have an SBS 2003 R2 Server that has been upgraded from WSUS 2.0 to
>>> 3.0 SP2.
>>>
>>> I need to move the 3.5gb database from Drive C to Drive W:. I can't
>>> find any documentation on how to move the database. I did fine info
>>> on how to move the content but not the database.
>>>
>>> Can anyone guide me step by step line by line on how to move the
>>> database from one drive to another on the same Server?
>>>
>>> Thanks in advance...
>
>