• Personally, thus far, I find SQL 2005's GUI for Log Shipping pretty good and easy to use

    for your script, the TARGET server/DB are always in NO RECOVERY? so it's more Mirroring than Log Shipping

    as with SQL 2005 Log Shipping, the TARGET server/DB is READ-ONLY

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005