• database mirroring provides a warm standy copy of the database.

    Log shipping works differently, log files are shipped to a remote database and applied. The database has 1 of 2 states, readonly or norecovery. Norecovery aloows subsequent log file restores and requires manual intervention to bring the database online. Read only provides a readonly copy of the database and clients are disconnected during log restores

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉