July 14, 2012 at 8:10 am
Whil eupgrading the SQL 2008 to SQL 2008 R2 we got the below error:
The pricipal contains one or more notifications or the objects cannot be dropped
we tried to repair but in vain even not allowing to install SP1
Can any one suggest how to procedd on this .
is this might causes any issues in furture if we leave as it is as the server is upgraded to sql 2008 R2 .
Replies are highly valuable and appreciated .
Thanks.
July 15, 2012 at 4:43 pm
Did the upgrade complete? Are you are R2? It's not clear what's broken exactly.
Also, do you mean you cannot apply SQL Server 2008 R2 SP 1 to the server? There are different service packs for SQL server 2008 and SQL Server 2008 R2. You cannot apply the same SP1 to both of these.
July 16, 2012 at 12:32 am
the version is showing sql 2008 R2 , when we tried to repair the db engine is geting failed with the error i mentioned in the above .
July 16, 2012 at 10:48 am
Repair with setup? If that didn't work, you should open a call with CSS. Or even uninstall, reinstall. Script out your jobs, principals (sp_help_revlogin), and then detach databases.
I haven't had a lot of errors with setup, but when I do, sometimes it's really broken. There should be a setupstp file (or similar name) on the system that logs everything that happened with the upgrade.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply