Viewing 15 posts - 1,621 through 1,635 (of 9,253 total)
even after you remove the database from the group the redo thread on the secondary may well still be applying transactions, this would be required to ensure the database state...
October 29, 2015 at 8:19 am
PretendDBA (10/28/2015)
Hi Perry, I'm not sure where would be more appropriate to post this question? the SQL 2012 section doesn't have a HA section?
Well it certainly doesn't belong in the...
October 29, 2015 at 5:03 am
PretendDBA (10/27/2015)
October 28, 2015 at 11:02 am
have you had a full backup run since the secondary database fell behind?
October 28, 2015 at 9:49 am
Snargables (10/28/2015)
I'm not trying to be rude here however none of these work properly and are returning extraneous results.
There's nothing wrong with either of the queries supplied above, the issue...
October 28, 2015 at 9:32 am
SQL Galaxy (10/27/2015)
October 28, 2015 at 5:31 am
SQL Galaxy (10/27/2015)
Is it mandatory to add 3rd node or...
October 28, 2015 at 5:25 am
Hadrian (10/28/2015)
I have this situation: -Two nodes cluster with two instances sql cluster 2012 and I need to move all on the new cluster 2012 with finally the...
October 28, 2015 at 5:13 am
anthony.green (10/28/2015)
Could you not just add in the new nodes to the existing cluster and evict the two old nodes?
Depends if the OS on the existing nodes supports this.
One way...
October 28, 2015 at 5:11 am
Snargables (10/27/2015)
A database name is a data type SYSNAME or VARCHAR(128), declare it as so or you may have issues if you have databases with really long names.
Snargables...
October 28, 2015 at 5:08 am
open up the errorlog, this will have details on the edition and version of sql server running
October 26, 2015 at 10:33 am
Ratheesh.K.Nair (10/24/2015)
October 26, 2015 at 10:30 am
do you have multiple instances on server002, that's what your diagram implies.
With multiple instances you'll need to pick a separate, unique port number
October 26, 2015 at 10:25 am
is this a synchronous or asynchronous session?
October 26, 2015 at 4:28 am
you're losing quorum and this is taking the cluster service offline, when this happens any cluster roles will also go offline.
for a 2 node cluster you should employ a witness,...
October 26, 2015 at 4:26 am
Viewing 15 posts - 1,621 through 1,635 (of 9,253 total)