Viewing 15 posts - 7,576 through 7,590 (of 9,241 total)
Markus (10/12/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:42 am
swethak13 (10/12/2010)
I tried,but it gives me the same error ..Please suggest.
Swetha K
can you post details of the query you are using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:29 am
The Redgate compiled help manual in your Redgate client install directory also has full details how to do this. Search the manual for either the "CONVERT" command to use command...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:28 am
This has all changed between versions SQL Server 2008 and SQL Server 2008 R2
which edition are you using?
Licensing all physical CPU's in the Host machine at Enterprise level in 2008...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 9:19 am
Halcyon (10/11/2010)
Evening Perry,can I confirm the steps:
1) Windows Cluster
2) SQL Server Cluster
3) Then add MSDTC to the SQL Server application
That's the steps you need to follow
Halcyon (10/11/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2010 at 4:48 am
Create a clustered DTC resource and put it into the same resource group as your clustered SQL Server instance.
Then create a mapping to the DTC resource for the SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2010 at 12:01 pm
Duran (10/11/2010)
Just to be clear, if I have 5 SQL instances on a cluster, I'd need 5 separate drives, each with their own drive letter? 5 SQL instances cannot put...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2010 at 11:06 am
Minto Minto(quendans) (9/30/2010)
login failed for user .the user is not associated with a trusted sql server connection :error 18452
what are the severity and state values for this message?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2010 at 9:50 am
Shared disk arrays can take many different formats. You could have a linux based server with disks shared over iSCSI, you may have a storage area network using fibre channel...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2010 at 7:21 am
you will need new disk resources to install the SQL 2008 instance, you wont be able to share the SQL 2005 disk resources!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 9, 2010 at 7:18 am
Halcyon (10/7/2010)
I would take the sql server application offline and then power down passive node, active node.Perry, your opinion?
Yes for a clean shutdown, the domain controller (which I guess is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2010 at 7:59 am
Go into failover cluster manager and expand the cluster. Right click Storage and select Add Disk!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2010 at 3:45 am
Marios Philippopoulos (10/6/2010)
Perry Whittle (10/6/2010)
Marios Philippopoulos (10/6/2010)
I just need a bit more ammunition to convince the SA team to make these changes.
Point them to the Microsoft KB and ask them...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2010 at 11:16 am
ogrishman (10/5/2010)
Hi,
I've created a test SQL Server clustering environment. I use SQL Server 2008 R2 on Windows Server 2008 R2 to do the experiment. Now I have one domain controller(also...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2010 at 10:48 am
Duran (10/6/2010)
when I try to add the extra disk, I just get an error saying that no suitable drives for clustering were found.
is the drive online and formatted?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2010 at 10:45 am
Viewing 15 posts - 7,576 through 7,590 (of 9,241 total)