Home Forums SQL Server 2014 Administration - SQL Server 2014 SQL with High availability, disaster recovery and online (read only) reports availability RE: SQL with High availability, disaster recovery and online (read only) reports availability

  • I have to provide few options. Then based on budget and resources, management will decide

    You are right that technical staff need to supply the options and that management will decide which one to proceed with. However, this needs the technical staff to fully understand the implications of the options they are presenting, and have the skills to recommend which is best for the business.

    From the questions you have asked I do not think you have the skills needed to recommend an option. If you recommend the wrong option or underestimate the work needed this could harm the survival of your business.

    In past situations where I have been asked to recommend a solution that is beyond my skill level to understand or scope, I have outlined the possible options and risks but recommended that the business employ a consultant organisation to review the choices and recommend the best way forward.

    Your Microsoft Account Manager will be happy to recommend suitable Gold Partners in your area that have the necessary skills, and can also suggest organisations from other countries if you do not feel confident about a local organisation. The consultant will bring to your organisation the skills needed to fully scope the options and workload, and will bring to you an opportunity to learn a lot from them while they do the work.

    My suggestion is to be honest about your skill levels to yourself and your management. You obviously understand the possible options, and this forum has given some of the risks they have. Ask Microsoft or Google for suitable Gold Partner organisations and ask them about their skills in SQL Server HA and DR. Present this information to your management along with a recommendation to employ who you think will be the best organisation to identify what is best for your business.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara