Viewing 15 posts - 1,696 through 1,710 (of 9,244 total)
That's the worse advice I've ever heard, what you need to do is provide more space to a clearly under provisioned system. Presumably when the system was first designed somebody...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2015 at 4:48 pm
crcoracle (10/3/2015)
Can I add a new node to an existing sql server 2012 cluster witthout stopping all the current resources?
Currently, there are 2 nodes and 3 sql server instances,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2015 at 4:43 pm
Since you're taking nightly fulls you won't be able to use a diff to synch the databases.
Restore all the logs or just restore the last full and any logs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2015 at 4:42 pm
PretendDBA (10/1/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2015 at 4:44 am
in a 2 node cluster with a FS witness, you should not be getting a failover when the witness is not available, you still have 2 out of 3 possible...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2015 at 9:28 am
you'll need local admin privileges to complete the install
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2015 at 8:23 am
AlwaysOn provides failover cluster instances which can be fully mitigated by VMware vmotion. AlwaysOn also provides availability groups which allows a number of readable secondary databases, this VMware does not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2015 at 6:48 am
Joy Smith San (10/1/2015)
I understand that we shouldn't shrink data files as it might cause heavy fragmentation along with log usage, high IO/CPU etc.
In a DB in which lot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2015 at 6:46 am
tcronin 95651 (9/30/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2015 at 6:43 am
As it's a named instance, let's assume you have
THENETWORKNAME\Instance
You want a new cluster with an availability group and all clients to connect for write and readintent connections.
Dump the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2015 at 10:10 am
no, only for the AG listener network name
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2015 at 9:58 am
if you really want to use replication with AGs start here
https://msdn.microsoft.com/en-us/library/hh710046(v=sql.110).aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2015 at 9:57 am
muthyala_51 (9/29/2015)
if for any reason AG fails over to async node, how replication behaves?
It won't, unless someone does this manually!!
Read my stairway link to HA on this site starting at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2015 at 4:42 am
Make no mistake this is an extremely involved task and will need careful planning. Couple of questions first though before I make a recommendation
so the clustered instance, is it a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2015 at 4:38 am
chrisph (9/24/2015)
@perry, 4 databases, one large one is causing the errors.
Full and log backups are set to primary, nightly fulls, 30 min tran logs.
SQL2014...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2015 at 3:42 am
Viewing 15 posts - 1,696 through 1,710 (of 9,244 total)