SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 sql 2012 always on plan
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tcronines
Starting Member

USA
8 Posts

Posted - 06/17/2014 :  14:35:46  Show Profile  Reply with Quote
Currently inherited the following

SQL Server 2008r2 active passive cluster running on windows 2008
Does log shipping to two other sql server 2008r2 on windows 2008 by log shipping one for
reporting 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 server

My plan was to upgrade the SQL 2008 R2 active passive cluster to 2012 and implement
Always 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

USA
36949 Posts

Posted - 06/17/2014 :  15:08:44  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tcronines
Starting Member

USA
8 Posts

Posted - 06/17/2014 :  15:54:18  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 06/17/2014 :  16:01:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
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.aspx

We 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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tcronines
Starting Member

USA
8 Posts

Posted - 06/17/2014 :  16:48:13  Show Profile  Reply with Quote
also were you on win2008r2 or 2012, just saw something on brent Ozar to stay away from Always on with Windows 2008r@
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 06/17/2014 :  16:55:55  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 06/17/2014 :  16:57:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tcronines
Starting Member

USA
8 Posts

Posted - 06/18/2014 :  09:51:02  Show Profile  Reply with Quote
the link is http://www.brentozar.com/sql/sql-server-alwayson-availability-groups/ Have also seen other references to win2008 server not being the best way to go.
Wondering how feasible it would be to upgrade current win2008/sql2008r2 cluster to win 2012/sql2012 cluster and then add ag
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 06/18/2014 :  12:36:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tcronines
Starting Member

USA
8 Posts

Posted - 06/18/2014 :  13:25:06  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 06/18/2014 :  13:41:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
Good luck and make sure you have backups that can be restored!

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000