Hmmmm.... that's what I thought so thanks for confirming.
The reason I'm asking is because I have a job which performs daily differential backups and another which does fortnightly full backups.
So consider the following scenario:
DAY 1 - FULL Backups
Day 2 - Differential Backups
DAY 3 - NEW DATABASE added
DAY 3 - Differential Backups (will fail the job because there isn't a full backup for the new database).
So I thought I could add a check in my sproc to look for entries in the backupset table where the type is D but this won't work where a database is created then restored using a full backup from another database.
I know the differential won't fail but it would be confusing to find a differential backup in the backup folder but no full backup.
am I making sense?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn