IT researcher (7/8/2013)
I am not using differential backup in my environment. i use full backup and transaction log backup.So in this case taking full backup and copy only full backup are same? Taking only full backup will not affect log chain i guess.
Correct. Taking full backups does not and has never broken the log chain.
Other than the 'not resetting differential base' a copy only full backup is exactly the same as a normal full backup in every way.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass