We do this (all beit only accross a city).

We have an a/p cluster on site and mirror our critical databases to our scf for dr (we have a p2p...

joeroshan (8/13/2009)

---

Node1 ...

I have never before removed a node from a cluster and as for adding it back after, i have never heard of this.

When you did the @@version on each node...

Roshan,

I agree with the last poster (in part), you definately have to have the SP3 exe local (to your active) when running.

When you talk about active and passive, is...

didnt, 'just' google. That was one of the resources i used.

If you actually read all the doc you would see that the KVS doc actually references that article.

And besides which...

Thanks Slammer,

So what should I do/check to verify?

Your completely welcome. :blush:

Hey Andy, I didnt know that. I've never seen the...

luckysql.kinda (8/6/2009)

---

I have read many books and blogs on sql server. Everywhere this is written that we need to reinstall if need to change the collation setting. IN sql server...

Agree with Steve, thats an awful lot of sql, for a relatively low powered box (our prod cluster is 128GB and we wouldnt dream of running more then 1 instance).

The...

CPU usage script can be found by reading ssc thread: http://www.sqlservercentral.com/Forums/Topic611107-146-1.aspx

Have also attached some scripts that may help your cause. 😉

Enjoy.

Umm off the top of my head, not sure.

If anyone has the answer this would be useful. I have a 5gb msdb under sql2000. Not sure how it...

Hey there,

Good news, this is actually reasonably simple and straight forward. I had huge troubles with this but then i...

Thanks guys. I actually used to use this solution before i rewrote in VB.

Didnt really do what i wanted but the prompt about setting the connection manager expression was just...

Hey Julio,

Saw this thread and it pretty much matches what i need.

I am setting 3 variable:

source_server

dest_server

current_server

current_server 'should' be which ever server the package is being deployed on (this i am...