May 16, 2014 at 12:54 pm
KTurkes (5/16/2014)
I have very little knowledge about AlwaysOn, and according to our SAP on MSSQL docs it should be in a MSCS environment. Alwayson servers will be in a cluster and disaster server will operate standalone and that was our main reason to plan such thing. If main site goes down disaster site will go up and when crisis is over we will reconfigure everything in prod site again.
No offense, but I think you should advise your customer that they get a consultant that does have knowledge of the technologies. It will be cheaper to pay someone to do it right than to pay them later to come fix it after it fails.
May 16, 2014 at 12:55 pm
KTurkes (5/16/2014)
I have very little knowledge about AlwaysOn, and according to our SAP on MSSQL docs it should be in a MSCS environment.
Perhaps it's worth getting someone involved in the project who does know more than a little about HA. It's very easy to get wrong, or not solve the customer's requirements and it's really bad for one's reputation when that happens.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2014 at 12:56 pm
OP: Sorry to be blunt but I have to ask: are you SURE that you are qualified to be setting up DR for this client? You are doing things/asking questions/making statements that someone responsible for doing that should really not be doing. A client that has a 3TB SAP database is bound to be a large one exposed to potentially tremendous financial losses and/or legal liabilities should an outage occur. I certainly hope you have some significant liability insurance!!
Of course it occurs to me to also wonder why a client with a 3TB SAP database a) doesn't already have a bullet-proof and well-tested DR plan in place, b) thinks it is acceptable to use async transaction transfer to the DR site and c) would hire someone with "very little knowledge about AlwaysOn" to implement that feature for them.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 16, 2014 at 1:04 pm
Looks like it took me just a bit longer than Robert and Gail to craft my "you probably shouldn't be doing this work (alone)" reply.
OP: You just had 2 SQL Server MCMs and me (15 year SQL Server consultant with almost 45000 man hours on the product) recommend in concert that you get help or a replacement for this work. I truly hope for all concerned that the message is well received.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 16, 2014 at 2:25 pm
Hello
Thanks for your valuable opinions. My responsibility on this project is to install and maintain SAP systems but customer wanted a disaster recovery documentation from my consultancy company. They already have an agreement with Microsoft and a system integrator firm but their responsibility is limited to only production system installation.
I know it doesn't really makes sense to implement a disaster recovery scenario before production system installation but according to their technical specifications agreement, we have to do it sadly. We already consultant SAP Turkey and Microsoft Turkey but they only gave us theoretical knowledge of AlwaysOn and HA solutions for SAP on MSSQL.
They are based on
http://help.sap.com/saphelp_nw73ehp1/helpdata/EN/44/d01a511f147162e10000000a44538d/content.htm and http://blogs.msdn.com/b/saponsqlserver/archive/2014/03/13/multi-site-clusters-for-sap-on-sql-systems-recommendations-amp-faq.aspx nothing more. Even SAP installation guides cover only HA installations of SAP systems but not database or operating system.
To be honest, I am not a core database administrator but I am SAP Basis administrator. I have basic knowledge of database systems which is enough SAP installations and maintenance, like installing it from SAP scripts, user administration, index and statistics maintenance, etc. I didn't have any SQL clustering experience because it wasn't my responsibility until now and at the moment I am searching for documents, guides, help on forums to finish my job.
Best regards
May 16, 2014 at 2:45 pm
Honestly, seriously, recommend to your client (and your company) that they look for a DB specialist to help them with their DR and that they let you work on your speciality, the SAP part. This is not something that you want to get wrong, this is not something you should be considering implementing based on only guides and documents.
I've set up mirroring and clustering in a lab environment multiple times and I still managed to screw it up when I implemented it at a client's site.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2014 at 6:58 pm
GilaMonster (5/16/2014)
Honestly, seriously, recommend to your client (and your company) that they look for a DB specialist to help them with their DR and that they let you work on your speciality, the SAP part. This is not something that you want to get wrong, this is not something you should be considering implementing based on only guides and documents.I've set up mirroring and clustering in a lab environment multiple times and I still managed to screw it up when I implemented it at a client's site.
Totally agree. I would even go so far as to say you want to get an expert that has a fair amount of SAP-on-SQL-Server experience. That is a very complex beast. I can recommend Allan Hirt at SQLHA without reservations, but I don't know if he has direct experience doing HA/DR specifically for SAP.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply