Viewing 15 posts - 2,851 through 2,865 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2014 at 7:19 pm
standard edition will support a 2 node cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2014 at 1:20 pm
Mac1986 (7/3/2014)
All databases are in Simple recovery model. Not sure what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2014 at 4:12 pm
sierra4 (8/20/2012)
dbi_dbid = 10 dbi_status =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2014 at 1:03 pm
PHXHoward (10/17/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2014 at 1:02 pm
Maxer (10/16/2014)
Mirroring with async seems like a good option for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2014 at 6:38 am
sej2008 (10/17/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2014 at 6:25 am
Viewing 15 posts - 2,851 through 2,865 (of 9,244 total)