• There is no 'best' method to replicate a database based on its size. There may be a 'best' method depending on what the business requirements are.

    If this is a real-life question (not an exam or interview question) then let us know what problem you are trying to solve and maybe we can help you.

    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