• Ok, please answer every question as fully as possible;

    1) why are you log-shipping at all? What are you hoping it will achieve for you (or is this purely experimental for your own knowledge)?

    2) why are you only backing up the log once a day?

    3) is this a production environment?

    4) are you "the DBA" or is there another DBA on-site?

    Thanks