SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

gangadhara.ms
Aged Yak Warrior

India
547 Posts

Posted - 02/22/2013 :  05:34:01  Show Profile  Reply with Quote
Hi,
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.

Thanks,
Gangadhara

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 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
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

prett
Posting Yak Master

USA
203 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

gangadhara.ms
Aged Yak Warrior

India
547 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"


Thanks,
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.08 seconds. Powered By: Snitz Forums 2000