Viewing 15 posts - 7,621 through 7,635 (of 9,241 total)
which quorum type did you specify when deploying the Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 11:52 am
--supply a date or getdate(), etc
declare @dtime datetime
select @dtime = '2010-07-04 10:25:21'
--pick out the parts you need
select cast(datepart(mi, @dtime) as varchar(2)) + ':' +
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 11:06 am
Duran
you add the disks as cluster resources and create a clustered DTC app for each one you want to deploy. You could even create them in the SQL groups they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 10:53 am
Hi
are you using a teamed connection for the heartbeat on your cluster nodes?
Also,
have you set your NIC settings and binding order correctly?
have you set the network types in Failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 9:11 am
SequelDBA (9/28/2010)
Yes it will plus be shared by other systems like VM and other Windows/Linux systems.
Don't expect any level of performance!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2010 at 12:19 pm
no problem, post the log when you are ready!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2010 at 8:24 am
ah yes 2008 is different, try exporting the log to a location you have permissions on
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2010 at 4:34 am
Cluster.log should be in the following folder
%systemroot%\cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2010 at 2:57 pm
Robert Davis (9/27/2010)
No, it wouldn't. I'd love to see what the cluster log says.
Me too!
Marios can you post details of the cluster.log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2010 at 1:08 pm
to create a grant script for all user stored procedures use the following
select 'grant execute on object::[' + sch.name + '].[' + pr.name + '] to userorrole'
from sys.objects pr inner...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2010 at 11:39 am
Ratheesh.K.Nair (9/19/2010)
The application wont connect to database...For remote connection you should enable both TCP\IP and NAMED PIPES
Simply not true. I have worked with SQL Server 2005 farms that have a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2010 at 11:23 am
Robert Davis (9/27/2010)
The description sounds a lot like cluster negotiation.
Hi
This wouldn't cause the original active node to reboot though would it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2010 at 10:48 am
the issue is you dont just have the sql server service resources. You also have any storage, IP and name resources. SQL server will not start until these are all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2010 at 3:22 pm
Arrange some downtime for the instance with your change manager. Go into cluster administrator and move the SQL resource group to a partner node, note how long it takes to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2010 at 8:30 am
Marios Philippopoulos (9/25/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2010 at 1:02 pm
Viewing 15 posts - 7,621 through 7,635 (of 9,241 total)