question

Ananya avatar image
Ananya asked

Need Suggestion for Setting SQL Server(s)

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.
log-shippinglogshipping
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
You planning on hosting these 2 new servers on the same host or separate hosts?
0 Likes 0 ·
Ananya avatar image Ananya commented ·
2 separate hosts....
0 Likes 0 ·

1 Answer

·
rvsc49 avatar image
rvsc49 answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
`+1` Yes. The key points here at that you must have Software Assurance, and the secondary has to be entirely passive.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.