Viewing 15 posts - 7,606 through 7,620 (of 9,244 total)
Vera-428803 (10/5/2010)
we work with VMware version 4.
There are 6 physical blade servers with 2 quadcore CPUs per blade (=48 CPUs).
They host 11 SQL servers which have 16 CPUs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2010 at 7:23 am
Install a new instance!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2010 at 1:36 am
Vera
Which VMWare edition\version are you using and how many virtual CPUs are assigned to each VM?
Do you place all of your SQL VMs on one host?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2010 at 1:34 am
The database you are restoring already exists on the server. If you want to overwrite it use
WITH REPLACE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2010 at 1:17 am
Hi
to find the quorum type in use do the following
go into Failover cluster manager and in the left hand pane click on the cluster name. In the centre pane the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2010 at 9:45 am
I get office, OS and server products to play with. Helps you to keep up with the latest MS technologies!
MS press are poor though IMHO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2010 at 2:35 pm
Hi Keith
are we talking SQL server user accounts or Windows user\group accounts?
The only way you'll lose permissions for the user in the database is to drop the database user! When...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2010 at 4:15 am
i have a technet subscription which i have just renewed for another year without any issues. I did however have issues with MS and misprints in one of their press...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2010 at 3:11 am
paul.knibbs (10/1/2010)
And stopping it will also tell you real quick if somebody actually IS using it, because you'll get a complaint! (Or something you have installed will stop working). 🙂
My...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2010 at 1:44 am
Sachin Vaidya (9/30/2010)
There is a different instance of SQL Server installed on this server but as of now in my knowledge, nobody is using that server apart from myself.
Aah now...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2010 at 1:13 am
Sachin Vaidya (9/29/2010)
Though I am...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 11:24 am
no problem. Take a bit of time to get used to failover cluster manager before going any further and you'll be golden 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 11:06 am
Marios Philippopoulos (9/30/2010)
Node 1: active node for instance SQL01
Node 2: active node for instances SQL02 and ABCD
Node 3: passive node
Instance SQL01 can only fail over from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 11:03 am
it doesn't setup the log, events are now monitored through the event viewer in failover cluster manager. The command below dumps a copy of the log to "cluster.log" for interrogation\support...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 10:45 am
have you checked the replication job history and status?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 8:15 am
Viewing 15 posts - 7,606 through 7,620 (of 9,244 total)