• Just go through the process of setting up Log Shipping in the GUI of SSMS and instead of hitting Ok to apply the action click the Generate Script > New Query Window button in the top left corner of the window. It will generate the T-SQL script you need. You can then incorporate that how you wish.

    Joie Andrew
    "Since 1982"