June 6, 2014 at 1:51 pm
looking at migrating current sql 2008r2 active/passive node with log shipping to two servers, one for true DR the other used as report server read only. Questions are as follows
Idea was to upgrade 2008r2 cluster to 2012
Add always on
Add two servers to new always on, one for DR , the other to act as reporting server.
? are as follows
1.Can I upgrade 2008r2 active/passive cluster to 2012 active/passive and alsp implement always on
If so can I upgrade current DR Server and reporting server to 2012, or do they need a rebuild?
Does thae hardware need to be same in all environments (including server type, storage type and logical drives)>
June 6, 2014 at 2:25 pm
tcronin 95651 (6/6/2014)
looking at migrating current sql 2008r2 active/passive node with log shipping to two servers, one for true DR the other used as report server read only. Questions are as followsIdea was to upgrade 2008r2 cluster to 2012
Add always on
Add two servers to new always on, one for DR , the other to act as reporting server.
? are as follows
1.Can I upgrade 2008r2 active/passive cluster to 2012 active/passive and alsp implement always on
If so can I upgrade current DR Server and reporting server to 2012, or do they need a rebuild?
Does thae hardware need to be same in all environments (including server type, storage type and logical drives)>
The questions you are asking shouldn't be asked by someone who is planning on doing those things if the answers are yes. PLEASE get qualified, experienced help with this project!! HA and DR can cause the loss of entire companies when it is done incorrectly or doesn't function as needed!!
Having said that, here's some thoughts:
1) I recommend to NEVER upgrade sql servers in place. This is ESPECIALLY true if clustering is involved.
2) Always on has LOTS of issues, nuances, limitations, caveats, provisos, etc. This is especially true if you plan on reading from one of the secondaries. For example, if you read from a secondary you can cause the MODIFICATION OF PRIMARY DATA STUCTURES!! Chew on that one for a bit.
3) hardware does not need to be the same (although it is strongly recommended on the A/P FCI).
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
June 6, 2014 at 2:39 pm
can a reporting server node also be used for the backups?
June 7, 2014 at 9:29 am
tcronin 95651 (6/6/2014)
can a reporting server node also be used for the backups?
Yes. As can checkdbs. But just knowing something can be done doesn't tell you why they are good or bad or indifferent to actually do.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply