sql server msde: issue of backup database on upgraded SQL2005 Express -- sql server msde

issue of backup database on upgraded SQL2005 Express

William
8/14/2006 9:06:02 AM

sql server msde:

Hi there,

After upgrading the MSDE2000 to MSDE2005, I ran the sql "backup database
mydb to disk = 'c:\temp\mydb.dmp'". However, I got some error message like
"Msg 207, Level 16, State 1, server ..., Line 1"
"Invalid colum name 'mirror_count'"

I checked the msdb, there is no system table. Does it mean the upgrade
precess is unsuccessful? And how can I restore the msdb?

Thanks

Re: issue of backup database on upgraded SQL2005 Express

Andrea Montanari
8/14/2006 7:10:14 PM

hi William,
[quoted text, click to view]

this can probably depend on http://support.microsoft.com/kb/907284/en-us,
"During upgrade from MSDE to SQL Server Express, the msdb database is not
upgraded", and it should be manually performed as indicated in
http://tinyurl.com/rf9yf
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply