Viewing 15 posts - 7,621 through 7,635 (of 9,244 total)
Pre create the empty service\application and then fill it with the appropriate resources (disk, DTC IP, DTC NAME, DTC service) and then install SQL Server 2008 selecting the pre created...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 8:12 am
pshaship (9/29/2010)
Does running the Cluster validation when one of the clustered nodes have SQL Server instance and databases, corrupt any data?Thanks
no reason why it should, in fact what makes you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 2:38 pm
cluster.log has gone in Windows 2008, you can generate a log though using the following command
Cluster log /gen /copy "C:\yourpath"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 2:33 pm
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
Viewing 15 posts - 7,621 through 7,635 (of 9,244 total)