Changing ftcatid on the fly?

Hi all
Quick question, I have a set of full text catalog files that we would
like to use to re-create a set of catalogs on a new build database, as
part of a build script. I have copied a set of files to a devstore on
out SAN with the intention of moving these to each local file system
before creating the catalogs.
I have the script and the bcp's writtten to create and populate both
the CRUD and the Search Databases. The search DB is the one with the FT
enabled.
My plan is to script the catalogs, then move the files to the local
file system, initially i wanted to create the new files with a dynamic
rename ( to follow the SQLxxxxx(dbid)yyyyy(ftcatid) naming convention)
however as all the hash files use the same name I am thinking it would
be easier to align the dbid and ftcatid to the ones specified on the
devstore files,
So this gives me a hardcoded dbid of 7, which i can recreate in the
build script by attaching and detaching dummy db's till i get the dbid
i need.
My question (finally!) is can i create the catalogs on the new machine,
then edit the ftcatid values in the sysfulltextcatalogs table to give
the catalkogs the desired ftcatid's (which would be 5,6,7)
Is this going to cause me a massive headache, or is there a better way
to create A number of prepoulated FT catalogs from a 'master' set?
regards
Barri Martin
SQL Bod - DWP.gov.uk
You can do this, but I would consult this article for a complete guide on
how to do it.
http://support.microsoft.com/kb/240867/
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<barri_j_martin@.yahoo.co.uk> wrote in message
news:1159372232.664003.16300@.i42g2000cwa.googlegro ups.com...
> Hi all
> Quick question, I have a set of full text catalog files that we would
> like to use to re-create a set of catalogs on a new build database, as
> part of a build script. I have copied a set of files to a devstore on
> out SAN with the intention of moving these to each local file system
> before creating the catalogs.
> I have the script and the bcp's writtten to create and populate both
> the CRUD and the Search Databases. The search DB is the one with the FT
> enabled.
> My plan is to script the catalogs, then move the files to the local
> file system, initially i wanted to create the new files with a dynamic
> rename ( to follow the SQLxxxxx(dbid)yyyyy(ftcatid) naming convention)
> however as all the hash files use the same name I am thinking it would
> be easier to align the dbid and ftcatid to the ones specified on the
> devstore files,
> So this gives me a hardcoded dbid of 7, which i can recreate in the
> build script by attaching and detaching dummy db's till i get the dbid
> i need.
> My question (finally!) is can i create the catalogs on the new machine,
> then edit the ftcatid values in the sysfulltextcatalogs table to give
> the catalkogs the desired ftcatid's (which would be 5,6,7)
> Is this going to cause me a massive headache, or is there a better way
> to create A number of prepoulated FT catalogs from a 'master' set?
> regards
> Barri Martin
> SQL Bod - DWP.gov.uk
>

Changing default location for FTDATA folder

When I restore a database it will place the catalogs in the default location
"C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA", how can I change this
default location so that when I restore a new database, the full text
catalogs are stored elsewhere ?
Changing the location of the catalog is only an option in SQL 2005.
Basically the full text catalog is in a different file group so you have an
option of exactly where you want to park it.
For SQL 200 I suggest you follow the instructions in
http://support.microsoft.com/default...b;en-us;240867
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"GMG" <nospam@.nospam.com> wrote in message
news:evgizv87FHA.3048@.TK2MSFTNGP10.phx.gbl...
> When I restore a database it will place the catalogs in the default
> location
> "C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA", how can I change
> this
> default location so that when I restore a new database, the full text
> catalogs are stored elsewhere ?
>
|||I am aware of this document and have found it very complicated and with a
lot of registry updates which makes me uneasy. I have finally opted for
dropping the catalog and then recreating it in a different location,
followed by full population.
Despite this when the documentation for sp_help_fulltext_catalogs states:
"NULL indicates the default directory determined during installation", my
question is how do I change this default directory ?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:equvR897FHA.3224@.TK2MSFTNGP09.phx.gbl...
> Changing the location of the catalog is only an option in SQL 2005.
> Basically the full text catalog is in a different file group so you have
an
> option of exactly where you want to park it.
> For SQL 200 I suggest you follow the instructions in
> http://support.microsoft.com/default...b;en-us;240867
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "GMG" <nospam@.nospam.com> wrote in message
> news:evgizv87FHA.3048@.TK2MSFTNGP10.phx.gbl...
>
|||Try this key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\SQL2000\MSSQLServer
And set it using this entry FullTextDefaultPath
Note that my instance name is SQL2000, so it could be
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer for you
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"GMG" <nospam@.nospam.com> wrote in message
news:O4vaSO%237FHA.3592@.TK2MSFTNGP12.phx.gbl...
>I am aware of this document and have found it very complicated and with a
> lot of registry updates which makes me uneasy. I have finally opted for
> dropping the catalog and then recreating it in a different location,
> followed by full population.
> Despite this when the documentation for sp_help_fulltext_catalogs states:
> "NULL indicates the default directory determined during installation", my
> question is how do I change this default directory ?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:equvR897FHA.3224@.TK2MSFTNGP09.phx.gbl...
> an
>