Viewing 15 posts - 3,421 through 3,435 (of 9,253 total)
GordonLiddy (3/28/2014)
Hi there!What happens when an automatic failover occurs, in a two server AlwaysOn Availability Group configuration where the secondary replica is configured as read-only?
If both replicas are...
March 28, 2014 at 6:42 am
lisafox.it (3/27/2014)
Observation - The virtual hostname is registered in DNS and it is resolving without any problem.
What command are you using to test the name resolution?
lisafox.it (3/27/2014)
March 28, 2014 at 6:34 am
chewychewy (3/26/2014)
Hi Guys,I'm quite confused and need your advise.
Understand that for AlwaysOn, we have 2 options:
1. AlwaysOn Failover Cluster Instances
2. AlwaysOn Availability Groups
For no 1 its more of...
March 27, 2014 at 7:55 am
Essentially the databases DB1,DB2,DB3,DB4,DB5 would be primary on Server A in an AlwaysOn group with secondary as Server B
The databases DB6,DB7,DB8,DB9,DB10 would be Primary on Server B with secondary as...
March 27, 2014 at 7:23 am
chewychewy (3/27/2014)
When in ASYNC mode, the primary replica commits transactions without waiting for acknowledgement that an asynchronous-commit secondary replica has hardened the log. Asynchronous-commit mode minimizes transaction latency on...
March 27, 2014 at 6:25 am
chewychewy (3/27/2014)
Need your advise here.
Anyone did such setup with AlwaysOn Avail Group?
We are looking into using AlwaysOn Avail Group for the purpose of HA.
Server A: Instance A with (DB1,DB2,DB3,DB4,DB5)...
March 27, 2014 at 6:06 am
cesarscorp2 (3/26/2014)
Thanks for the recomendation but I checked these options but the problem persist.I think the problem is about the service account but I don't know What is the account?
first...
March 27, 2014 at 4:13 am
You remove just the SP via add/remove programs it rollback for you. The backups are for if anything goes bang! !
March 25, 2014 at 10:36 am
[Url=http://technet.microsoft.com/en-us/library/bb510680.aspx] This[/url] details the compatibility levels.
There's no real need to panic. Why not set up a test system and verify the platform.
March 25, 2014 at 10:34 am
Backup all your databases and install SP1
If you don't like it remove it via Add\Remove programs 😉
March 25, 2014 at 9:51 am
Caruncles (3/25/2014)
Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT...
March 25, 2014 at 9:45 am
As i said previously, once you do this
jayoub (3/24/2014)
I would like to take these two servers off the network (disable the NIC)
You will not be able to do this
jayoub (3/24/2014)
March 25, 2014 at 9:34 am
Do you have permission within AD to create SPNs?
If not you'll need a domain admin to do this for you.
The instance name in the SPN registration is only for connections...
March 25, 2014 at 9:26 am
Caruncles (3/25/2014)
March 25, 2014 at 8:55 am
Grace09 (3/24/2014)
1. It is a cluster environment
2. It is named instance
3. It is not using default tcp port.
Would the followings be...
March 25, 2014 at 5:27 am
Viewing 15 posts - 3,421 through 3,435 (of 9,253 total)