MSteynberg (11/28/2014)

---

Hi Guys,

I hope you can clarify something for me.

I have a 3 node SQL Server Failover cluster in my production environment. Each Node has 24 cores.

I...

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...

jumpin (11/26/2014)

---

From what I've read adding the WSFC components to the server after SQL has already been installed is problematic and one of the ways around it is to uninstall...

peteroc (11/26/2014)

---

Hello,

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...

which edition of SQL Server 2005 and 2012 are you upgrading between

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...

what OS is the server at?

ramana3327 (11/26/2014)

---

Hi,

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...

jumpin (11/26/2014)

---

From what I've read adding the WSFC components to the server after SQL has already been installed is problematic and one of the ways around it is to uninstall...

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...

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...

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...

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...

sminar (11/25/2014)

---

Thank you, that did help. If I'm understanding this correctly, restoring to a different server won't cause conflicts with its existing keys, as long as the cert name is...

check the sql srever error log during the instance startup, can you obfuscate it and post details here.