MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

stsadm prupgradecheck InvalidDatabaseSchema

  Date: Sep 17    Category: MOSS    Views: 995

I just installed WSS & MOSS sp2 on a 2007 Enterprise Edition dev box. I ran
the preupgrade check and it failde on the InvalidDatabaseSchema check. I looked
in the log and saw the eroor :
[DatabaseSchema] [ERROR] [3/11/2011 4:15:59 PM]:

I looked in WSS_Content_XXXXXXSSP and saw that someone had mistakenly addded a
table to theis databse. (it's a copy of a table from another non-sharepoint db
on that sever). So I just dropped the table.

I reran the preupgrade check, and got the same message. So I fuigured it was
caching a scjhema somewhere so i reset iis, and then even reboot the server, bit
still is gives me the error.

Doesn anyone know how I can get rid of this meessage? or should I just ignore it
and move on?



1 Answer Found

Answer #1    Answered On: Sep 17    

Are you saying that you deleted the table but not the database itself?
You are not supposed to modify any of the SharePoint databases. So you
might need to export and import all the sites and then create a new web
application and SharePoint database to correct this issue. And then
delete the old web application and content database(s).

Didn't find what you were looking for? Find more on stsadm prupgradecheck InvalidDatabaseSchema Or get search suggestion and latest updates.