SQL Server Forums - SQL 2008 Upgradation

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

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

Topic

gangadhara.ms
Constraint Violating Yak Guru

India
497 Posts

Posted - 02/22/2013 : 05:34:01

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
1775 Posts

Posted - 02/23/2013 : 02:12:30

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

prett
Posting Yak Master

USA
161 Posts

Posted - 02/25/2013 : 00:07:00

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).

gangadhara.ms
Constraint Violating Yak Guru

India
497 Posts

Posted - 02/27/2013 : 00:01:10

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

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.