Viewing 15 posts - 1,501 through 1,515 (of 9,253 total)
your architecture document that you created for this system will indicate where you wish the production service to run, consult that first
December 29, 2015 at 8:50 am
check your storage backing the Tempdb. SQL Server is sending requests to the disk subsystem and they're not returning in a timely fashion
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...
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...
December 29, 2015 at 8:24 am
rodbloke (12/18/2015)
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...
December 17, 2015 at 6:24 am
can you provide more information, screenshots maybe?
What does the failover cluster manager view show
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...
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...
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...
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...
December 17, 2015 at 6:08 am
what is the exact version of your client tools
December 16, 2015 at 9:13 am
curious_sqldba (12/15/2015)
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 😉
December 16, 2015 at 9:05 am
Viewing 15 posts - 1,501 through 1,515 (of 9,253 total)