SQL Server Performance

Transactiopn bakup

Discussion in 'SQL Server Log Shipping' started by Reddy, May 1, 2007.

  1. Reddy New Member

    I am doing a full backup and then applying trans bakups every day to update the DB so tht it can be sync with source DB. if something fails to restore my logs and can not update latest data do I need a full backup at tht point or I can just continue applying my trans bakup to get updated.

    Thanks!
    "He laughs best who laughs last"

  2. satya Moderator

    Yes having applied the full database backup will bring the latest transactions on the destination database. then you can continue the transaction log backups.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page