| Author |
Topic |
|
tcronines
Starting Member
8 Posts |
 Posted - 2014-06-17 : 14:35:46
|
| Currently inherited the followingSQL Server 2008r2 active passive cluster running on windows 2008Does log shipping to two other sql server 2008r2 on windows 2008 by log shipping one forreporting one for DR passive no connection, all servers Enterpise edition.It has one sql license for the active/passive cluster and one for the reporting serverMy plan was to upgrade the SQL 2008 R2 active passive cluster to 2012 and implementAlways On. kill log shipping and utilize always on for reporting server and DR server.We have SA on SQL Licenses so i do noth think I need to purchase anything.So the question is is this a realistic plan? don't have resources to build whole new world have to do with what I have. if this is a doable plan is it a requirement for the reporting node and the dr node to have the exact same server and drive configuration? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-17 : 15:08:44
|
| Yes this is a realistic plan and is what we did recently. We were previously using transactional replication for reporting and database mirroring for DR. With AlwaysOn Availability Groups, we used the readable secondary for reporting and the AG mirroring for DR. Same number of licenses.The huge benefit was eliminating transactional replication. For your environment, the benefit is even greater since log shipping has downtime every time the tlog restore occurs.The servers can be quite different in an AG cluster, one could be physical and the other virtual. Probably the only things that matter is the OS and SQL versions. Even drive configuration can be different as you can specify WITH MOVE when doing the initial restore.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
tcronines
Starting Member
8 Posts |
Posted - 2014-06-17 : 15:54:18
|
| thanks that's what i thought one more quick one, can the reporting server (which is only used during business hours) that full backups can also be done against this server |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-17 : 16:01:06
|
| Yes, but I don't see the point since it's a copy-only full backup and not one that log backups can use for the chain. You can't run diffs on the secondaries.http://msdn.microsoft.com/en-us/library/hh245119.aspxWe run all backups on the primary replica.If backups are impacting performance, then I would look into your IO subsystem. Backups should really not be noticed.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tcronines
Starting Member
8 Posts |
Posted - 2014-06-17 : 16:48:13
|
| also were you on win2008r2 or 2012, just saw something on brent Ozar to stay away from Always on with Windows 2008r@ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-17 : 16:55:55
|
| We deployed Windows 2008 R2 as the server team wasn't yet ready for Windows 2012. Do you have the link for that article? I would bet it's "old".Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-17 : 16:57:26
|
| I should add that I recently switched companies, and the new company is using Windows 2012. But basically the AG setup is identical to what we did at the previous company.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tcronines
Starting Member
8 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-18 : 12:36:20
|
| That is a general link. Which link inside of there has the info you are referring to? Or rather, just post the quote here.Yes you can upgrade in-place, but that has the most risk. It is recommended that you do a side-by-side approach instead.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tcronines
Starting Member
8 Posts |
Posted - 2014-06-18 : 13:25:06
|
| Kind of in a bind here, need to go to 2012 regardless, but only money for upgrade in place for windows and sql 2012 cluster. Kind of a like Apollo 13, failure is not an option |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-18 : 13:41:41
|
| Good luck and make sure you have backups that can be restored!Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
sql 2012 always on plan