• SQL* (9/17/2012)


    I have read in blogs/books that, when we are setting up mirroring/Log shipping we have to take the both Full backup&Transactional backup and restore them to the secondary server as an initial step.

    That's Database Mirroring, Log shipping doesn't require you to take at least one log backup, you only need to initialise the secondary database from a full backup of the primary or let the Log Shpping wizard do this for you.

    Furthermore, for mirroring Books Online goes on to say the following

    Books Online


    Typically, at least one log backup must be taken on the principal database, copied to the mirror server, and restored on the mirror database (using WITH NORECOVERY). However, a log backup might be unnecessary, if the database has just been created and no log backup has been taken yet, or if the recovery model has just been changed from SIMPLE to FULL.

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

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