Tag Info

New answers tagged

0

I used this script in a custom report once. ;WITH AG_Stats AS ( SELECT AGS.name AS AGGroupName, AR.replica_server_name AS InstanceName, HARS.role_desc, Db_name(DRS.database_id) AS DBName, DRS.database_id, ...


3

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


0

Script to create read only rounting: /* set up read-only intent routing Test it: sqlcmd -S "YOUR_LISTENER" -d dbname -Q "select @@servername" -Kreadonly sqlcmd -S "YOUR_LISTENER" -d dbname -Q "select @@servername" */ ALTER AVAILABILITY GROUP [AG] MODIFY REPLICA ON N'node1.DevDomain.com \instance' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL)); -- not ...



Top 50 recent answers are included