We have an issue with the OS on SERVER1 which existed in some fashion or other at least since we migrated it to a Virtual Machine. We are planning on creating two new servers to replace this server: * SERVER2 – Primary replacement with log shipping * SERVER3 – Secondary server – recipient of logs Would like to have opinion on how to migrate the functions of the existing SERVER1 to these new servers and create a “Hi-Avail” type setup but staying inside our existing license structure. Additionally when we spin up these servers both the OS and SQL version will go to current versions.
With previous versions of Sql Server, if you were not planning on using the 2nd server for reporting in a Log Shipping scenario, you did not have to license the secondary. I have read that the SA (Software Assurance) type licensing which goes along with Sql 2014 and above, it includes a secondary at no extra cost.