Upgrade to SQL Server Express causes problem with backup

[Wayne]

After upgradeing an existing MSDE instance to SQL Server express a backup
won't work. When using the following statement: "Backup Database APPDBTo
Disk='C:\Data\Archives\APPDB.bak' With Init" we get the error "Invalid
column name 'mirror_count'". If we rebuild the MSDB by running instmsdb.sql
then the backups work again. I found one post in another newsgroup about
this but was wondering if others were running into this problem or if there
is something we are doing wrong in upgrading our MSDE instances. We've
haven't been able to upgrade one yet without this problem. Just wanted to
check before calling support.

Thanks,
Wayne

[Roger Wolter[MSFT]]

That's a know issue with upgrading MSDE instances. The cure as you found is
to run the script to upgrade msdb.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Wayne" <Wa...@discussions.microsoft.com> wrote in message
news:79EDBA23-308C-49C2...@microsoft.com...

[Wayne]

Roger,
Thanks for getting back to me. Okay then that is what we will do. Do you
know if there are there any KB articles or anything on MSDN about it? I
could not find anything so I'm wondering if I was searching on the correct
thing. If it's a known issue I would have thought my search would have found
it right away.

Thanks,
Wayne