SOLVED: Upgrading MCMS 2001 to MCMS 2002 SP2 throws SQL error
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > Microsoft Content Management Server > SOLVED: Upgrading MCMS 2001 to MCMS 2002 SP2 throws SQL error




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    SOLVED: Upgrading MCMS 2001 to MCMS 2002 SP2 throws SQL error  
Anders Borum


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-20-07 06:15 PM

Hi Stefan and Kevin

I already made sure the MCMS 2001 database has plenty of space (also
reported as an issue that could lead to the described error). A friend of
mine did in fact (a few hours ago) manage to upgrade the database on a SQL
Server 2000.

It turned out that the customer had left two views in the database (I
noticed them, but didn't think they would cause any problems - wasn't sure
whether they were part of the original MCMS 2001 schema). I tried to delete
the views on my local database (running SQL Server 2005) but the upgrade
broke through 50% of the migration process.

The upgrade did however complete on the SQL Server 2000 environment once the
views were deleted (weird it failed in the 2005 environment.

Thanks for the help :-)

--
With regards
Anders Borum / SphereWorks
Microsoft Certified Professional (.NET MCP)







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 10:12 PM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register