Viewing 15 posts - 2,851 through 2,865 (of 9,253 total)
SQLAssAS (10/22/2014)
approach 1:
Prod - shared storage between server 1 and 2
Server1: clustered SQL instance with availability group as primary
Server2: Passive server for clustered instance...
October 22, 2014 at 4:48 am
more importantly, as well as adding the listener you must correctly configure the read only routing within the AlwaysOn group to offload the read only intent connections to an AlwaysOn...
October 22, 2014 at 4:38 am
ramana3327 (10/20/2014)
I am looking for some best practices of migrating 2008r2 to 2014 and implementing always on.
a simple google search would produce the results you require. VMWare have an...
October 22, 2014 at 4:36 am
shahgols (10/20/2014)
TheSQLGuru, you are the man, that is the correct answer! tHANK YOU!
Have you even bothered to read my replies??
October 20, 2014 at 7:19 pm
standard edition will support a 2 node cluster
October 20, 2014 at 1:20 pm
Mac1986 (7/3/2014)
All databases are in Simple recovery model. Not sure what...
October 20, 2014 at 1:17 pm
Jacek Falkiewicz (10/19/2014)
Hi,Any idea why index reorganizing is 10 times slower then rebuild with "ONLINE=ON" clause?
Thanks,
Jacek
You can't just go by the logical frag %.
Could you post the full details of...
October 20, 2014 at 10:10 am
Nirav_Joshi (10/18/2014)
I have following infrastructure at par. where i have 3 server in WFC(Windows Failover cluster) Win2012 and out of 3 servers two servers are active/passive cluster with SQL...
October 19, 2014 at 1:38 pm
sej2008 (10/19/2014)
it is node majority.
OK, with a 2 node cluster, Majority Node Set is not the correct qorum type. Shutting down will node will take the cluster offline on the...
October 19, 2014 at 1:26 pm
Ozzmodiar (10/17/2014)
I'm curious Kevin,What would be the advantage to this as opposed to a contained database?
Thanks!
The only real advantage is that the databases are easier to move as they have...
October 18, 2014 at 1:32 am
The script kevin has posted is exactly the script i would use,mit will retain the logins sid and hashed password. The only thing it doesnt extract are server role memberships
October 17, 2014 at 4:12 pm
sierra4 (8/20/2012)
dbi_dbid = 10 dbi_status =...
October 17, 2014 at 1:14 pm
shahgols (10/17/2014)
I am not sure if I designed the AlwaysOn wrong, but every time we fail over from primary server to another server, my applications cannot connect because the sql...
October 17, 2014 at 1:03 pm
PHXHoward (10/17/2014)
October 17, 2014 at 1:02 pm
Maxer (10/16/2014)
Mirroring with async seems like a good option for...
October 17, 2014 at 6:38 am
Viewing 15 posts - 2,851 through 2,865 (of 9,253 total)