Tag Info

New answers tagged


No, it is nothing to be worried about - the Agent isn't considered a clustered service to SQL Server simply because it can't fail over on its own. You should test a failover and be confident that SQL Server Agent will start on the other node and that jobs will run etc. (sometimes there can be local dependencies that won't exist on the other node(s)), but ...


My Network Admin. wants an "Active/Active" with shared storage There is no such thing as an "active/active" instance. Only one node of the cluster can be hosting the SQL instance for a failover cluster instance. If by "active/active" you mean having two different SQL Server failover cluster instances, that is possible. Why shared storage? That's an ...

Top 50 recent answers are included