One of the main features we use to assure our databases are always available is SQL Server’s Always On Availability Group (AG).
How I set up one was installing Windows Failovercluster Manager on all SQL Servers, creating a new cluster and adding the servers into that cluster.
Then I’d create a new folder on a witness server, go back to the Failovercluster Manager and configure the quorum witness.
At last I’d open the SQL Server Configuration Manager, check the box for Always On Availability Groups on your SQL instance, start up SSMS, create AGs, add all servers and create listeners.
Make sure the Failovercluster has rights to create Active Directory Objects since the listeners are created in the same OU your cluster is in!
To migrate a Report Server we would backup ReportServer and ReportServerTempDB, drop the new default databases and restore the old databases on the new server . . .
One of the things I got confused about is the physical backup location. If you reconfigure the SQL Server to store new backups at a . . .