sqlskj4000 (7/10/2012)
What can be done so that the diff backups ignore the snapshots and treat the full backup as their checkpoint?
Ask the people running the snapshot backups to please not snapshot the databases. That's about the only option.
I tried manually marking the snapshot entries as 'is_copy_only'=1 in backupset. But that didn't seem to help.
No it won't. Changing the history record doesn't change the properties of the backup. It just changes the history in the table and makes it incorrect.
That's like updating a shop's inventory list and marking chicken as a vegetable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability