Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
hi how to move wsus interntal database to diff drive

Answered hi how to move wsus interntal database to diff drive

  • Monday, April 16, 2012 9:53 AM
     
     
    Sign In to Vote
    0

    hi

    currently my wsus datbase and wsuscontent is inside in e: drive i need to move to F drive

    i have moved wsuscontent using wsutil  movecontent command .now i need to move my databse also to these location .please note  iam using windows internal data base not sql

    regards

    ankith

     

All Replies

  • Monday, April 16, 2012 8:37 PM
     
     Proposed Answer
    Sign In to Vote
    0

    Hi Ankithmaster,

    Have you checked the following links?

    1. Managing WSUS 3.0 Storage: http://technet.microsoft.com/en-us/library/hh328578(WS.10).aspx
    2. Migrating WSUS: http://technet.microsoft.com/en-us/library/ee822824(WS.10).aspx

    The second link has the following info which might help:

    noteNote
    If the source server is using Windows Internal Database, the database name is \\.\pipe\mssql$microsoft##ssee\sql\query

    Hope this helps

    • Proposed As Answer by MathewEllison Monday, April 16, 2012 8:37 PM
    •  
     
  • Tuesday, April 17, 2012 3:15 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    Windows Internal Database uses SQL Server technology as a relational data store for Windows roles and features only, such as Windows SharePoint Services, Active Directory Rights Management Services, UDDI Services, Windows Server Update Services, and Windows System Resources Manager. Windows Internal Database is also known as Microsoft SQL Server Express Embedded Edition.

    There are five main steps to the process of moving a database within Windows Internal Database:

    1. Stop the affected services.

    2. Detach the databases

    3. Move the database files.

    4. Reattach the databases.

    5. Restart the services.

    Detail process, please refer to this article:

    Move Windows Internal Databases to a different drive (Windows SharePoint Services 3.0)
    http://technet.microsoft.com/en-us/library/dd277864(v=office.12).aspx

    Note: this is an article write for Windows SharePoint Services, but also apply to Windows Server Update Services.

    For more information please refer to following MS articles:

    How to Move WSUS Content and Database Files to a Different Volume
    http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx
    Migrate from Windows Internal Database to SQL Server
    http://technet.microsoft.com/en-us/library/dd939918(v=ws.10).aspx

    Lawrence

    TechNet Community Support

     
  • Wednesday, April 18, 2012 4:57 AM
     
     
    Sign In to Vote
    0

    Hi there,

    To change the location of local WSUS update storage:

    Open a command shell.

    Navigate to the directory that contains WSUSutil.exe:

    cd %WSUSInstallationDirectory%\Tools.

    Type the following command:

    wsusutil.exe movecontent contentpath logfile [-skipcopy]

    For example, type:

    wsusutil.exe movecontent F:\WSUS1\ F:\move.log

    where F:\WSUS1 is the new path for local WSUS update storage, and F:\move.log is the path to the log file.