moving wsus 3.0 int. database to a new hard disk
We have Windows Server 2003 and are also running WSUS 3.0 on our machine and it uses internal WSUS database at E:\WSUS. Some time prior, we connected a new hard drive on the server. Can anyone tell me how to move the database to teh new hard drive E:\WSUS? If yes then tell me how to do it? Thanks for any idea.
re: moving wsus 3.0 int. database to a new hard disk
The wsusutil command-line utility is used in managing WSUS servers and is located in the WSUSInstallDir\Tools folder of WSUS servers. The table below summarizes the different parameters that can be used with this utility, and later sections explain the syntax and usage of each parameter. For more information, check out this link - http://technet.microsoft.com/en-us/l.../cc708604.aspx
re: moving wsus 3.0 int. database to a new hard disk
You can try to move the database, for that you will need to use the sqlcmd.exe utility. Follow the below method:
- First of all stop the Update Services service.
- After that try to run sqlcmd to detach the SUSDB database from the database server.
- Now you have to move the SUSDB.mdf and SUSDB_log.ldf files to the new location on Drive F:
- After that you need to run sqlcmd to attach the SUSDB database back to the database server in the new location.
- Lastly, you have to start the Update Services service.
If you want some more information on using sqlcmd to attach ot detach databases then check out the SQL Server 2005 Books at http://msdn2.microsoft.com/en-us/library/ms190794.aspx
re: moving wsus 3.0 int. database to a new hard disk
Thank you for the suggestions. I have now moved the WSUS contents with "wsusutil movecontent" and WSUS is using the Windows Internal Database. Should I also use the above method of sqlcmd to move the database to the new location F:\WSUS?