Reviews:
 ·Cox HSI
| reply to wsusadmin123
Re: [2K3] move wsus db to a sql server 2005 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 |
|
| 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 |
|
 techjoePremium
join:2004-02-20
Warrenville, IL
kudos:1 | Swap osql with sqlcmd, same thing - wrong term. It's all in the article I linked in my first post.
--
Baka wa shinanakya naoranai |
|
