wsusadmin123
@mindspring.com
| [2K3] move wsus db to a sql server 2005
recently we installed a sql server 2005 on a new box.
we also have a wsus using its windows internal database.
now we are trying to move wsus's db to this new sql server for a better db management.
The articles I found is so difficult, which I don't prefer at all.
I am thinking about any easy way to manage this db migration.
What I am thinking about is that I am going to uninstall the WSUS and keep its database. Then I copy and attach this in sql server manually.
When it is attached, then I reinstall the WSUS and point this database back.
What do you think?
Steve |
|
yaplej
CCNA
Premium
join:2001-02-10
White City, OR
 ·Charter Pipeline
| I went through the same problem. I finally just uninstalled WSUS and did a fresh install. I kept the downloaded updates, and I think it noticed the files were already there, but it was a long time ago.
--
Open Source WAN Accelerator
»trafficsqueezer.sourceforge.net/ |
|
techjoe
Premium
join:2004-02-20
Schererville, IN
1 edit | reply to wsusadmin123
It's really easy.
»technet.microsoft.com/en-us/libr···10).aspx
Scroll down to "To migrate the WSUS database from a Windows Internal Database instance to an instance of SQL Server 2005 on a remote server"
You also need to set the registry key (on the front end) from »www.wyckedone.net/2008-09-21/mov···nt-81311
Front End = WSUS (IIS) Server
Back End = SQL 2005 Server
It shouldn't take you more than 30 minutes including copying the files. I've done it a few times in WSUS 3 and it's really simple. Moving just SQL is easy, the tricky part is if you want to move WSUS itself to a whole new server and keep all updates and such.
--
Baka wa shinanakya naoranai |
|
wsusadmin123
@covad.net
| said by techjoe  :It's really easy. » technet.microsoft.com/en-us/libr···10).aspxScroll down to "To migrate the WSUS database from a Windows Internal Database instance to an instance of SQL Server 2005 on a remote server" You also need to set the registry key (on the front end) from » www.wyckedone.net/2008-09-21/mov···nt-81311Front End = WSUS (IIS) Server Back End = SQL 2005 Server It shouldn't take you more than 30 minutes including copying the files. I've done it a few times in WSUS 3 and it's really simple. Moving just SQL is easy, the tricky part is if you want to move WSUS itself to a whole new server and keep all updates and such. thanks for your information.
however, i don prefer installing any additional stuffs on wsus server. like i could install sql studio management to detach the wsus db but it takes space.
"To migrate the WSUS database from a Windows Internal Database instance to an instance of SQL Server 2005 on a remote server
On the front end server: Install Microsoft SQL Server 2005 with the Server and Client Tools option and SQL Server 2005 Service Pack 1 or a later version. This step will enable you to use the SQL Server Enterprise Manager on the front end server"
Is there any way i don have to install anything to detach db, like just copy that db and attach it in a remote sql server?
please advise.
Thanks.
Steve |
|
BillRoland
Premium
join:2001-01-21
Ocala, FL
clubs:
·Cox HSI
| said by wsusadmin123 :
Is there any way i don have to install anything to detach db, like just copy that db and attach it in a remote sql server?
please advise.
I'm just guessing but I would imagine you could detach and attach using the OSQL command line, but really just installing the Tools is easier.
--
"Don't steal. The government hates competition."
Beyond AM. Beyond FM. XM |
|
techjoe
Premium
join:2004-02-20
Schererville, IN | reply to wsusadmin123
Your WSUS server is so tight on space you can't install OSQL? 
Sorry, not much else I can suggest. Good luck.
--
Baka wa shinanakya naoranai |
|
wsusadmin123
@covad.net
| reply to BillRoland
mmm..that sounds like a good option, i guess i can use osql to do the following, let me know what u think about this
1. use osql to detach it
2. copy and attach it in sql server
3. grant appropriate permssion
4. change registry in wsus
5. restart the service of wsus
i assume this procedure makes the wsus use the database in the sql server.
i don know if it actually works......what do u think?
steve |
|
techjoe
Premium
join:2004-02-20
Schererville, IN | Swap osql with sqlcmd, same thing - wrong term. It's all in the article I linked in my first post.
--
Baka wa shinanakya naoranai |
|
