There are four types of high availability options available in Microsoft SQL server. All the options are different from each other. For example, Log shipping, Mirroring and Always On works on database level while Replication works on database objects level. 100 more words
Tags » Always On
Failed to perform AlwaysOn Manual Failover using the wizard - Availability-group DDL Operations are permitted only when you are using the master database .
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts… the weapon of choice will be the SSMS Failover wizard – and why not its does the job nicely and give us some nice visuals as it progresses through each failover. 782 more words
Recently, all the SQL server DBAs in and around the world have started with or have been on the “AlwaysOn Bandwagon”. So, eventually, if the technology doesn’t get replaced by a fresh High Availability technology or gets out-dated, we’ll get requests to move the data files into fresh new disks or add new files to a database in an AG (Availability Group). 261 more words