...
Some customers have chosen to deploy a single stand-alone instance for production with the database mirroring to a second stand-alone DR instance that can also be used for reporting. This type of configuration requires manually cutting over in a failure scenario, but allows the second SQL server to be actively used instead of sitting underutilised.
| Warning | ||
|---|---|---|
| ||
The AMS database requires Service Broker to be enabled. If you are going to create a mirror or availability group ensure that Service Broker is enabled first. If you do not then the installation of AMS will fail and you will need to remove the group before the installation will succeed. |