SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL 2008 Upgradation - upgrade advisor issues
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Aged Yak Warrior

549 Posts

Posted - 02/22/2013 :  05:34:01  Show Profile  Reply with Quote
I am doing in-place upgrade from 2005 to 2008.Upgrade adviser shows 2 issues.

Please help me to fix these issues.

1.Invalid object name "sys.symmetric_keys"
2.Full-text search has changed in SQL Server 2008.


Flowing Fount of Yak Knowledge

United Kingdom
2153 Posts

Posted - 02/23/2013 :  02:12:30  Show Profile  Visit jackv's Homepage  Reply with Quote
For the first one - what service pack are you running on sql server 2005? are you on at ;east on service pack 3?

Jack Vamvas
Go to Top of Page

Posting Yak Master

211 Posts

Posted - 02/25/2013 :  00:07:00  Show Profile  Visit prett's Homepage  Reply with Quote
For this error message: Full-text search has changed in SQL Server 2008: Please refer to In-Place Upgrade and Side-by-Side Upgrade sections in SQL Server 2008 Upgrade Technical Reference Guide, which listed detailed actions to upgrade Full-Text Search to SQL Server 2008 (applies to SQL Server 2008 R2 as well).
Go to Top of Page

Aged Yak Warrior

549 Posts

Posted - 02/27/2013 :  00:01:10  Show Profile  Reply with Quote
Yes for the first issue i am on SQL server 2005 with SP3 but still its showing in upgrade advisor report with "when to fix -before"

Gangadhara MS
SQL Developer and DBA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000