• Hi, thanks for the reply,

    1) I am giving you answer for your first question, log-shipping will help to decrease the disaster recovery. if production server will go down , user will sit odlw they can use secondary database.

    2) I am not taking log backup. one more DBA is there he is taking , he asked , but he is finding time slot to run log backup frequently. for that one we are planning . we are just strtup comapny , so it will take some time to grow.

    3) this one alredy included in 2nd question , please see the 2nd point.

    4) this question , i have already given.

    I have some doubt. please clarify.

    1)by that time can we configure log-shipping in this environment, hence log backup is runing once in everyday.

    2) shall i stop taking log backup , so that chain will not break.