Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-12-27 : 16:13:34
|
| Im reading this article http://www.sqlservercentral.com/articles/Administration/2987/ as im about to take databases from SQL 2000 to SQL 2005.1. We will backup and restore all databases.2. Set Mode to 903. Update Statictics DBCC UPDATEUSAGE (Databasename)How do i see if i have full text indexes on database.Any other steps missed?Thanks |
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2007-12-27 : 17:59:32
|
| If I am understanding you correctly you want to view your Full Text Catalogs within the database on SQL Server 2005. If that is true, then once you open up the Microsoft SQL Server Management Studio expand your server. Find the database that is supposed to have the Full Text Catalogs and expand the database object tree and look for a folder that reads "Storage". Expand the Storage folder and right underneath that you will see a folder that reads "Full Text Catalogs". You will find your catalogs in there.Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-12-28 : 08:00:22
|
| Im moving databases from SQL 2000 to SQL 2005 some of the databases have the full text catalogs and i wondering if i delete first before moving to SQL 2005. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-28 : 23:35:27
|
| Don't have to since sql2k backup doesn't include full text catalog at all. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-12-29 : 09:13:17
|
| Thats good news i try one of the databases that has it on and see.I must have read when someone did a detach and attach thats good im doing restores. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-29 : 21:54:26
|
| Not even with detach/attach, only moves over when you upgrade whole sql2k instance to sql2k5 with in place upgrading. |
|
|
|
|
|
|
Full text indexes