Viewing 15 posts - 1,696 through 1,710 (of 9,253 total)
How does this handle databases with multiple files?
It's concerning that it automatically drops the target database first if it exists.
October 4, 2015 at 11:56 pm
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...
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,...
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
October 4, 2015 at 4:42 pm
PretendDBA (10/1/2015)
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...
October 1, 2015 at 9:28 am
you'll need local admin privileges to complete the install
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...
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...
October 1, 2015 at 6:46 am
tcronin 95651 (9/30/2015)
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...
September 30, 2015 at 10:10 am
no, only for the AG listener network name
September 30, 2015 at 9:58 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...
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...
September 30, 2015 at 4:38 am
Viewing 15 posts - 1,696 through 1,710 (of 9,253 total)