Viewing 15 posts - 1,621 through 1,635 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2015 at 5:03 am
PretendDBA (10/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2015 at 11:02 am
have you had a full backup run since the secondary database fell behind?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2015 at 9:32 am
SQL Galaxy (10/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2015 at 5:31 am
SQL Galaxy (10/27/2015)
Is it mandatory to add 3rd node or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2015 at 5:08 am
open up the errorlog, this will have details on the edition and version of sql server running
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2015 at 10:33 am
Ratheesh.K.Nair (10/24/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2015 at 10:25 am
is this a synchronous or asynchronous session?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2015 at 4:26 am
mw112009 (10/22/2015)
See attached
Use the ALTER DATABASE ... MODIFY FILE statement. For help on this check BOL. Also see my guide at this link[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2015 at 10:50 am
Viewing 15 posts - 1,621 through 1,635 (of 9,244 total)