GilaMonster (2/3/2009)
The only time the COPY_ONLY option is necessary is if you are doing differential backups as without that a full backup will reset the differential base.
Full backups never break the log chain.
Are you doing differential backups?
wow, thats great.. i didnt knew this :w00t:
I was thinking that log shipping is just an automation of the normal transaction log backups and restores which we normally perform. but it didnt fail even after i took full backups, log backups and even diff backups in the source server. There is no need for COPY_ONLY
Now I dont have any issues. Am continuing my usual backup schedules (to tape) in my production server, and also using log shipping to the DR server.
Great, that i got the best advice from u. Thanks a lot for ur help 🙂