techjoe
Premium
join:2004-02-20
Schererville, IN
1 edit | reply to wsusadmin123
Re: [2K3] move wsus db to a sql server 2005
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 |
|
wsusadmin123
@covad.net
| 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 |
|
