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

Discussion in 'Windows Server' started by Bikini Browser, Sep 4, 2009.

  1. 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
     
    Bikini Browser, Sep 4, 2009
    #1
    1. Advertisements

  2. Bikini Browser

    Al Williams Guest

    Al Williams, Sep 4, 2009
    #2
    1. Advertisements

  3. Bikini Browser

    Al Williams Guest

    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?
     
    Al Williams, Sep 4, 2009
    #3
  4. 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
     
    Bikini Browser, Sep 4, 2009
    #4
  5. Bikini Browser, Sep 4, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.