Tag Info

New answers tagged

2

Native functionality, no. AlwaysOn Availability Groups have the containment of database. Server objects (Agent jobs, logins, alerts, etc.) just simply don't play a HADR role with availability groups. Whenever you run into the need to ensure that server-level objects exist on all replicas, or that they only execute on [particular_replica] then you will ...


1

You can review this MSSQLTip to get more information on what active/active and active/passive mean in regards to SQL Server Clusters: SQL Server Clustering Active vs Passive In your situation, and based on your comments, the only thing you need to do is configure the dependencies for your resources. So if I have a cluster resource for the the SQL Server ...


2

Listen to your adviser. By restoring a backup, you are essentially replacing the database schema and data. You will need to turn synchronization off, remove the DB from HA and perform the restore on the primary and replica, leaving the replica version in a restoring state by using WITH NORECOVERY. Once your backup is in place, put the DB back into HA and ...


0

Please note that I'm refraining from offering licensing advice due to recent discussion indicating that this probably isn't wise. Based on your comments, you have the following groups defined within Cluster Administrator: Cluster Group File Server Group SQL Group Your "Cluster Group" probably includes a "Cluster IP Address", "Cluster Name", and ...



Top 50 recent answers are included