Viewing 15 posts - 2,686 through 2,700 (of 9,241 total)
which edition of SQL Server 2005 and 2012 are you upgrading between
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 27, 2014 at 3:24 am
Kevin has excellent points here but to add
1) Yes, you need someone who's on the ball with Windows Server Failover Clusters, you also need to understand a great deal about...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 3:40 pm
what OS is the server at?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 3:24 pm
ramana3327 (11/26/2014)
We are planning to 2014 migration in few days.
I need help in configuration.
ServerA----- ServerA1
ServerB---- ServerB1
In serverA we have 5databases. And making 5databases as availability group. The replica is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 1:33 pm
jumpin (11/26/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 9:01 am
In a clustered environment there are various pieces of meta data that are stored which you wouldn't see in a standalone environment.
Likelihood is if you do this it will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 5:21 am
you should be able to form the WSFC without uninstalling the existing instance.
First things to check are the OS and hardware between the existing server and its intended
failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 5:17 am
to check the currently active primary for a group use the following
selectgroup_id
, primary_replica
, primary_recovery_health
, primary_recovery_health_desc
, secondary_recovery_health
, secondary_recovery_health_desc
, synchronization_health
, synchronization_health_desc
from sys.dm_hadr_availability_group_states
Looking at the replica level will only show replica info, looking...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 5:11 am
if local firewall has IMCP blocked ping is normally the first to be blocked but check it anyway.
Check the port in use for the named instance and check the browser...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2014 at 12:45 pm
sminar (11/25/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2014 at 12:41 pm
check the sql srever error log during the instance startup, can you obfuscate it and post details here.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2014 at 4:07 am
plaid_draco (11/24/2014)
Jeffrey Williams 3188 (1/31/2012)
plaid_draco (1/31/2012)
Thank you for the quick responses! Very helpful.I guess my assumption that an active-active cluster would avoid that problem is unfounded. 😀
Second,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2014 at 3:22 am
Adam Bean (11/24/2014)
Ya got me again. Previously I was specifying the database, this time I was not. As soon as I specified the database, it indeed took me to 03.
:cool:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 8:01 am
Adam Bean (11/24/2014)
When I connect to the listener with ;ApplicationIntent=ReadOnly, it still lands on the current primary (which is SQL01\AO1):Shouldn't I have landed on SQL03 first?
Are you specifying the listener...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 7:50 am
It doesnt get the server roles but i use this
SELECT'CREATE LOGIN [' + name + '] WITH PASSWORD = ' +
sys.fn_varbintohexstr(password_hash) +
' HASHED, SID = ' + sys.fn_varbintohexstr(sid) +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 7:47 am
Viewing 15 posts - 2,686 through 2,700 (of 9,241 total)