Tagged Questions
1
vote
1answer
86 views
Set up AlwaysOn in virtual environment: How to add nodes to domain? [closed]
On a beefy server, I have a few Virtual Machines (VMs) running. On one of those, I have Domain Controller (DC) with a domain name (ex:SQL.AD.COM) running successfully. Now, I need to add the other VMs ...
3
votes
1answer
99 views
Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2?
[Cross post from StackOverflow]
Brent Ozar published this webcast (slides, video with free registration) entitled "Real-Life SQL Server 2012: AlwaysOn Lessons Learned", in which he repeatedly states, ...
2
votes
1answer
66 views
AlwaysOn Availability Groups: Confusion with some concepts
In Sql Server 2012, I am trying to install Failover Clustering to configure AlwaysOn Availability Groups. When I run Cluster Validation test wizard, it comes back with a lot of errors. One of them ...
1
vote
0answers
30 views
when can AG primary replica be a different host to WFC primary?
To set up an Availability Group with two servers, the servers both participate in a Windows Failover Cluster.
I've seen cases after certain failover modes where the primary IP address in the cluster ...
4
votes
2answers
1k views
I cannot get SQL Server 2012 to install the database engine
SQL Server 2012 installation on a standard Windows 2008 R2 server. It refuses to install the database engine or sql replication.
During the installation I got no errors saying that it wasn't ...
5
votes
1answer
135 views
De-Cluster SQL Server 2012
Is there any way to 'de-cluster' an instance of SQL Server 2012 that was installed using the 'New SQL Server Cluster Installation' option? We are having issues with the failover portion of clustering ...
6
votes
2answers
671 views
SQL Server 2012 Standard Edition - multiple instances and memory utilization
If we have multiple instances of a SQL Server 2012 Standard Edition (which has a 64 GB memory limit) on one server which has 192 GBs of RAM, do both instances only have access to the first 64 GBs of ...
