SQL Server Performance Forum – Threads Archive

Transactiopn bakup

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"

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.

]]>