1. Welcome Guest! In order to create a new topic or reply to an existing one, you must register first. It is easy and free. Click here to sign up now!.
    Dismiss Notice

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

Discussion in 'Windows Home 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


    (787) 637-9100
     
  2. Al Williams

    Al Williams Guest

  3. Al Williams

    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?

    --
    Allan Williams




    Al Williams wrote:<!--coloro:blue--><span style="color:blue <!--/coloro-->
    > The database shouldn't be too big so why bother?
    >
    > A google of "wsus3 move database" gave me:
    >
    >
    >
    >
    > Bikini Browser wrote:<!--coloro:green--><span style="color:green <!--/coloro-->
    >> 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... <!--colorc--><!--/colorc--><!--colorc--><!--/colorc-->
     
  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





    "Al Williams" <donotreplydirect@usenewsgroup.com> wrote in message
    news:OKr$Z5ZLKHA.4432@TK2MSFTNGP03.phx.gbl...<!--coloro:blue--><span style="color:blue <!--/coloro-->
    > The database shouldn't be too big so why bother?
    >
    > A google of "wsus3 move database" gave me:
    >
    >
    >
    > --
    > Allan Williams
    >
    >
    >
    >
    > Bikini Browser wrote:<!--coloro:green--><span style="color:green <!--/coloro-->
    >> 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...<!--colorc--><!--/colorc-->
    >
    > <!--colorc--><!--/colorc-->
     
  5. Folks:

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



    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" <donotreplydirect@usenewsgroup.com> wrote in message
    news:e1zooHaLKHA.3708@TK2MSFTNGP02.phx.gbl...<!--coloro:blue--><span style="color:blue <!--/coloro-->
    > 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:<!--coloro:green--><span style="color:green <!--/coloro-->
    >> The database shouldn't be too big so why bother?
    >>
    >> A google of "wsus3 move database" gave me:
    >>
    >>

    >>
    >>
    >> Bikini Browser wrote:<!--coloro:darkred--><span style="color:darkred <!--/coloro-->
    >>> 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...<!--colorc--><!--/colorc--><!--colorc--><!--/colorc-->
    >
    > <!--colorc--><!--/colorc-->
     

Share This Page