Search:  

 
theme to white backgroundlet page decide theme
HomeFind ServiceReviewsISP NewsFAQsForumsToolsDatabaseAbout 
 
   All ForumsHot TopicsGallery






how-to block ads


 
Forums » Tech and Talk » OS and Software » No, I Will Not Fix Your #@$!! Computer » [2K3] move wsus db to a sql server 2005
Search Topic:
 Share Topic:
RSS topic:
toggle:
flat / full
normal / watch
Posting:
Post a:
Post a:
HP LJ 5000 is printing random characters over many pages »
« (topic move) Comcast connection to my mail server...  
AuthorAll 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 · Reply to this


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
to forum · permalink · 2009-07-06 12:05:29 · Reply to this


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
to forum · permalink · · 2009-07-06 20:47:56 · Reply to this
-
Forums » Tech and Talk » OS and Software » No, I Will Not Fix Your #@$!! ComputerHP LJ 5000 is printing random characters over many pages »
« (topic move) Comcast connection to my mail server...  

Wednesday, 25-Nov 06:39:05 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
Most commented news this week
· [103] New AT&T Ad Campaign Hits Back At Verizon
· [85] New Bill Takes Aim At Higher Verizon ETFs
· [84] Apple Joins AT&T Verizon Snark Fest
· [40] In-Flight Internet Headed For Bumpy Landing?
· [32] Senators Want ACTA Made Public
· [30] Earthlink Suffers From Major E-mail Outage
· [30] AT&T Offers New Prepaid Wireless plans
· [28] Frontier Increases Modem Rental Fee
· [20] Despite Billions In USF Fees, U.S. Libraries Lack Bandwidth
· [16] Vivendi In Way Of Comcast's NBC Desires
Most people now reading
· Windows 7 boot manager editing questions [Microsoft Help]
· Mysterious $800 Cash Deposit? [General Questions]
· [Rant] Damn Sermons through my speakers! [Rants, Raves, and Praise]
· "ISP owners could face jail under child porn bill" - CBC [Canadian Broadband]
· HOW-TO: QoS and Tomato (fixes "choppy voice") [MagicJack]
· Climate Change Scandal Erupts After Email Hack. [Security]
· Getting ready to pull the trigger, still have cold feet. [VOIP Tech Chat]
· A small rant [Security]
· What is the spell hit cap for a lvl 80 full arcane spec mage [World of Warcraft]
· Extjs grid combo box. [Webmasters and Developers]