how move data files of replica server to another drive of the same

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.
Does somebody have procedure that explains how to move data files of replica
server to another drive of the same server?
Thank you.

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.
> Does somebody have procedure that explains how to move data files of replica
> server to another drive of the same server?
> Thank you.

Alex,

Forwarded to the WSUS newsgroup for the poster's convenience. This NG is
for
issues with Windows Update.

NNTP link for OE: WSUS NG
news://msnews.microsoft.com/microsof...pdate_services


MowGreen [MVP 2003-2009]
===============
*-343-* FDNY
Never Forgotten
===============

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
>

"Alex" <Alex@discussions.microsoft.com> wrote in message
news:A1627E3E-9736-4D86-91DD-13EF554D2030@microsoft.com...
> 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.

A tutorial on how to use SQLCMD, OSQL, or SSMS is really beyond the scope of
this group.

But here's a starting place for the documentation on using SQLCMD:
http://msdn.microsoft.com/en-us/library/ms162773.aspx





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

OK.
Sqlcmd cannot do it. There is no attach/de-attach option.
Probably the most practical way is:
Download the free SQL 2005 EE CTP and connect to the local WSUS instance and
detach and move the mdf/ldf's and reattach them.
I found it here:
http://www.microsoft.com/downloads/d...displaylang=en
Thank you.


"Lawrence Garvin" wrote:

> "Alex" <Alex@discussions.microsoft.com> wrote in message
> news:A1627E3E-9736-4D86-91DD-13EF554D2030@microsoft.com...
> > 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.
>
> A tutorial on how to use SQLCMD, OSQL, or SSMS is really beyond the scope of
> this group.
>
> But here's a starting place for the documentation on using SQLCMD:
> http://msdn.microsoft.com/en-us/library/ms162773.aspx
>
>
>
>
>
> --
> 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
>
>

I downloaded and installed the SQL 2005 Management Studio Express
(SQLServer2005_SSMSEE.msi)
At first could not access the Windows Internal Database, then found that one
has to connect to \\.\pipe\mssql$microsoft##ssee\sql\query on the local
machine.
That works.


"Alex" wrote:

> OK.
> Sqlcmd cannot do it. There is no attach/de-attach option.
> Probably the most practical way is:
> Download the free SQL 2005 EE CTP and connect to the local WSUS instance and
> detach and move the mdf/ldf's and reattach them.
> I found it here:
> http://www.microsoft.com/downloads/d...displaylang=en
> Thank you.
>
>
> "Lawrence Garvin" wrote:
>
> > "Alex" <Alex@discussions.microsoft.com> wrote in message
> > news:A1627E3E-9736-4D86-91DD-13EF554D2030@microsoft.com...
> > > 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.
> >
> > A tutorial on how to use SQLCMD, OSQL, or SSMS is really beyond the scope of
> > this group.
> >
> > But here's a starting place for the documentation on using SQLCMD:
> > http://msdn.microsoft.com/en-us/library/ms162773.aspx
> >
> >
> >
> >
> >
> > --
> > 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
> >
> >