Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Registering your SQL Servers participating in availability groups by availability group listener name is the alternative method for the following reasons:

  • You can perform backups and recovery on databases on the primary replica of the availability group.
  • Your backups are performed based on the availability group properties' backup preferences.

Keep in mind:

  • Only the listener's name needs to be licensed.
  • Policy jobs in the SQL Server agent on the new primary need to be recreated in a failover event.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse