Re: [2K3] move wsus db to a sql server 2005

Author	All Replies
BillRoland Premium join:2001-01-21 Ocala, FL clubs: ·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
	to forum · permalink · · 2009-07-06 02:16:35 ·
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
wsusadmin123 @covad.net	to forum · permalink · 2009-07-06 12:05:29 ·
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
techjoe Premium join:2004-02-20 Schererville, IN	to forum · permalink · · 2009-07-06 20:47:56 ·


Wednesday, 02-Dec 22:14:22	Terms of Use \| Privacy Policy \| Hosting by www.nac.net - DSL,Hosting & Co-lo \| feedback \| contact over 10 years online! © 1999-2009 dslreports.com. page compression OFF