2.1 DB upgrade fails, MS SQL Server
-
Hi! After upgrade from 2.0 to 2.1 (Windows Server 2008 R2 with SQL Server 2008 R2) the services wont start and when reading logs it's because the DB is in wrong version.
Trying to rung dbmbgr upgrade ends in this:
Upgrading database...
Upgrading from version 410 to 411
Converting table tdata_25: failed
Rolling back last stage due to upgrade errors...
Database upgrade failed -
Solved or, at least we came through the problem. We deleted the data in the tables reporting the errors and then the db-upgrade worked.
-
-
Can somebody please run upgrade with -t option and post output? Also, content of failed table before upgrade could be helpful.
Best regards,
Victor
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login