Re: moving WUS to another partition
- From: "bass_player [SBS-MVP]" <bass_player@xxxxxxxx>
- Date: Fri, 14 Sep 2007 09:12:55 +0800
Actually, you do not need to stop the WSUS services (or any other services
using any SQL Server/MSDE database) just to detach the database. This is
only necesary if you do not want anybody connected to the database while you
do a detach.
"Manfred Zhuang [MSFT]" <v-mzhuan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:s1jJUeg9HHA.5532@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello Patrick,
Thank you for posting here.
From your post, I understand that you used wsusutil to move the WSUS
content to D drive and would like to know if we can delete WSUScontent in
C
drive. In addition, you also want to know if we can move WSUS database.
For the first problem, we can delete WSUScontent in C drive directly.
However, to ensure there will not be a problem, I suggest you rename
WSUScontent in C drive to WSUSold and monitor the situation for several
days. If WSUS works properly, let's then delete WSUSold.
For the second problem, we can perform following steps to move the
database:
Run CMD and then run following commands one by one:
net stop "update services"
net stop w3svc
osql -E -S %computername%\wsus -Q "exec sp_detach_db 'SUSDB'"
md d:\WSUS\MSSQL$WSUS\data
move "C:\WSUS\MSSQL$WSUS\Data\SUS*.*" d:\WSUS\MSSQL$WSUS\data
osql -E -S %computername%\wsus -Q "exec sp_attach_db @dbname=N'SUSDB',
@filename1=N'd:\WSUS\MSSQL$WSUS\data\SUSDB.mdf',
@filename2=N'd:\WSUS\MSSQL$WSUS\data\SUSDB_log.ldf'"
net start "update services"
net start w3svc
Please try the above steps at your earliest convenience. If you have any
concern, please feel free to let me know.
Best regards,
Manfred Zhuang(MSFT)
Microsoft Online Newsgroup Support
Get Secure! - www.microsoft.com/security
=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check
the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In
doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
| Thread-Topic: moving WUS to another partition
| thread-index: Acf02D8UNlNiccR3TsSkuqAOMshvfw==
| X-WBNR-Posting-Host: 207.46.193.207
| From: =?Utf-8?B?UGF0cmljaw==?= <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx>
| Subject: moving WUS to another partition
| Date: Tue, 11 Sep 2007 18:00:01 -0700
| Lines: 12
| Message-ID: <C74473D6-3869-4226-812E-92FB5769DEA1@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2929
| Newsgroups: microsoft.public.windows.server.sbs
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:62323
| NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| I am out of room on the tiny 20GB C: partition that Dell preinstalled
SBS
| 2003 on. I've moved all databases and shared folders to D: already. I
ran
| the wsusutil.exe command line utility with the movecontent option to
move
the
| WSUS content over to D:. According to the log, it all moved correctly,
but I
| have 2 questions.
| 1. It appeared to copy the data, not move it. It's still on
| C:WSUS\WSUScontent as well as D:\WSUS\WSUSconent. I'm afraid to delete
the
| C: copy. can I?
| 2. What about the C:\MSSQL$WSUS directory? I wish that would have been
| moved, too, but it's still sitting on C:. What can I do with that?
|
| Patrick
|
.
- Follow-Ups:
- Re: moving WUS to another partition
- From: Manfred Zhuang [MSFT]
- Re: moving WUS to another partition
- References:
- RE: moving WUS to another partition
- From: Manfred Zhuang [MSFT]
- RE: moving WUS to another partition
- Prev by Date: Re: ISA 2004 on SQL2000 NOT MSDE
- Next by Date: Re: SQLVDI - ErrorCode=(288)Attempt to release mutex not owned by call
- Previous by thread: RE: moving WUS to another partition
- Next by thread: Re: moving WUS to another partition
- Index(es):
Relevant Pages
|
