Monday, January 26, 2009

Backup Jobs Fail After Upgrading to SQL 2008

Various literature on this says to recreate your backup plans once the SQL 2008 upgrade is done.

After looking into the issue I discovered the root cause of the issue was that the “allow updates” global configuration value had been set to true. When I set it back to false, the backup plans worked again. I know the “allow updates” property is supposed to allow users to update system tables but if you don't need to do that on a regular basis then this solution might be fine or a quick workaround until you can go through the tasks of recreating each individual plan.

No comments: