Viewing 15 posts - 2,686 through 2,700 (of 9,244 total)
I see nothing in there that provides any reasonable evidence.
In an ideal scenario you would deploy the cluster before installing your instances, but a standalone instance of SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 27, 2014 at 7:57 am
jumpin (11/26/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 27, 2014 at 6:17 am
peteroc (11/26/2014)
I've read lots about why you shouldn't normally shrink databases in posts such as this:
http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/
But we have a situation where we are required to copy the live db to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 27, 2014 at 4:13 am
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
Viewing 15 posts - 2,686 through 2,700 (of 9,244 total)