Viewing 15 posts - 1,501 through 1,515 (of 9,244 total)
check your storage backing the Tempdb. SQL Server is sending requests to the disk subsystem and they're not returning in a timely fashion
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2015 at 8:48 am
gorripativ (12/28/2015)
Will windows cluster name and sql cluster name can be same or should be different?Thanks in advance
Each clustered role will require its own unique Virtual IP address and virtual...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2015 at 8:29 am
curious_sqldba (12/18/2015)
Anyone has hands on experience setting up geoclustering in 2012? Are there any gotcha's i should be worried about?
What exactly are you planning to deploy on a geographical scale.
A...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2015 at 8:24 am
???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2015 at 7:51 am
rodbloke (12/18/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2015 at 7:50 am
alter database ... modify file is the supported way to move a database file.
Just be careful what you're typing as the files new location, it will accept whatever you execute...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2015 at 6:24 am
can you provide more information, screenshots maybe?
What does the failover cluster manager view show
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2015 at 6:19 am
if TCP port 5022 is already used by the endpoint on the sql 2012 instance you'll need to select another TCP port that's not in use for the sql 2008...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2015 at 6:17 am
sn@ke (12/9/2015)
instance01/name01 Port: 10000instance02/name02 Port: 10001
please note, connections should be made to
instance01ame01
instance02ame02
it's not recommended to set 1433 on named instances, use a high...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2015 at 6:16 am
gorripativ (12/16/2015)
Hi,Our environment has A-p clustering set up on 2 nodes. when failover occurs sql instance is not failovering to other node.
What errors were you getting?
What did you try...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2015 at 6:10 am
New Born DBA (12/16/2015)
I am trying to change the Log Auto-Growth setting to 8 GB,
even with fast disks this will take time to initialise the space.
You'll likely get timeout issues...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2015 at 6:08 am
what is the exact version of your client tools
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2015 at 9:13 am
curious_sqldba (12/15/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2015 at 9:12 am
Dougieson (12/14/2015)
My mistake, I was thinking about Failover Cluster Instances >.<You can configure a Two Node environment with Standard
This has been possible since sql server 2005 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2015 at 9:05 am
acrutchley (12/10/2015)
I am looking for a few pointers with moving and upgrading a 2008 two node cluster to new hardware and upgrading to 2014, which will also include moving...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2015 at 9:02 am
Viewing 15 posts - 1,501 through 1,515 (of 9,244 total)