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…
>
>
