Hi all...i'll be migrating some databases to a new server and am looking at all the dependencies and extra stuff that needs to be moved along with the DBs - such as full-txt catalogs. I've run a few stored procedures to identify which databases have full-txt catalogs - but even though they exist i'd like to know if they are actually being used. Our developers should be able to tell me but they are taking ages to get back to me - probably cause some of the apps are so old & they know nothing about them!
How can i find this out? I can see the modified date on some of files within our ftdata folder is recent, but does this definitely indicate that they are in use? Also - how do you map a catalog to one of these folders as they have obscure names..
Any help appreciated!
Div
How can i find this out? I can see the modified date on some of files within our ftdata folder is recent, but does this definitely indicate that they are in use? Also - how do you map a catalog to one of these folders as they have obscure names..
Any help appreciated!
Div
