View Single Post
  #3 (permalink)  
Old 10-14-2008
Alex
 

Posts: n/a
Re: how move data files of replica server to another drive of the
Lawrence, Thank you for your answer. it is exactly what I want to know:
moving database.
I am using windows internal database and I want to move it to another HD, so
I have to use Sqlcmd -deattach from one HD and attach to another.
please give me exact command line of this command: I did not find
deattach/attach option.

Moving content I did use normal procedure:
http://www.wsuswiki.com/ContentOnNetworkDrive
and it works regerdless what do you have: master or replica mode.
Thank you again.


"Lawrence Garvin" wrote:

> > Alex wrote:
> >
> >> I am running WSUS ver 3 with SP1 in master – replica mode.
> >> Now I have to move database of one of my replica server to another drive.
> >> From D:\Wsus to G:\Wsus.

>
> >> Command wsusutil.exe movecontent does not work because it is replica
> >> server.

>
> Actually 'wsusutil movecontent' doesn't work for moving the database because
> it's the wrong command.
>
> The 'movecontent' command is to move the CONTENT (~\WSUSContent folder) from
> one location to another.
>
> >> Does somebody have procedure that explains how to move data files of
> >> replica server to another drive of the same server?

>
> Now, you really need to make up your mind... >))
>
> Do you want to move the =DATABASE= as you stated above in your second
> sentence.
>
> Or do you want to move the =CONTENT=?
>
> To move the database, you need to do the following:
> 1. Stop the Update Services service.
> 2. Use SQL Server Management Studio or SQLCmd to detach the SUSDB database
> from the database server.
> 3. MOVE the SUSDB.mdf and SUSDB_Log.ldf files to the desired destination.
> 4. Use SQL Server Management Studio or SQLCmd to attach the SUSDB database
> back to the database server.
> 5. Restart the Update Services service.
>
>
> --
> Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
> Principal/CTO, Onsite Technology Solutions, Houston, Texas
> Microsoft MVP - Software Distribution (2005-2009)
>
> MS WSUS Website: http://www.microsoft.com/wsus
> My Websites: http://www.onsitechsolutions.com;
> http://wsusinfo.onsitechsolutions.com
> My MVP Profile: http://mvp.support.microsoft.com/pro...awrence.Garvin
>

Reply With Quote