Sql 2005 Backups and Schema Changes Interactions

Sql 2005 Backups and Schema Changes Interactions
StackOverflow.com –

I’m not clear about the interaction between database schema changes and differential backups on sql 2005.

Lets say I do a Full backup right right now.
Then I perform some schema changes.
Then I do a diff backup.

What happens? Do I need to create another FULL backup? Are my schema changes and any data in those new schema bits included in my diff backup?

This entry was posted on Monday, February 09th, 2009 and is filed under StackOverflows. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.