Log shipping and Full Text

I setup log shipping on my production server which is a part of Replication
and went ahead and created a report server using log Shipping however my
Report server is missing Full Text and it don't allow me to create it saying
it is read only database.
I am running SQL server 2000 with service Pack 2
Is there any way I can also bring Full text on Report Server my databasde is
huge and full text takes couple of days to create so I was exploring a
solution that can take full txet catalog from my production server and copy
it to Reprot Server.
Thanks
Tanweer
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
"Tanweer" <Tanweer@.discussions.microsoft.com> wrote in message
news:820818D0-7F18-45F0-8B82-9ACBF539F8BE@.microsoft.com...
> I setup log shipping on my production server which is a part of
Replication
> and went ahead and created a report server using log Shipping however my
> Report server is missing Full Text and it don't allow me to create it
saying
> it is read only database.
> I am running SQL server 2000 with service Pack 2
> Is there any way I can also bring Full text on Report Server my databasde
is
> huge and full text takes couple of days to create so I was exploring a
> solution that can take full txet catalog from my production server and
copy
> it to Reprot Server.
> Thanks
> Tanweer
|||oops, that went out prematurely. You could follow these steps every time you
want your database synchronized -
http://support.microsoft.com/default...b;en-us;240867
Or you could use replication. If you use replication you will have to build
your tables and full-text indexes in advance on the subscriber. Then in your
article properties make sure you select the delete all data option.
SQL 2005 replication will support this directly.
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
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u$9GFtsaFHA.3488@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
>
> --
> 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
> "Tanweer" <Tanweer@.discussions.microsoft.com> wrote in message
> news:820818D0-7F18-45F0-8B82-9ACBF539F8BE@.microsoft.com...
> Replication
> saying
databasde
> is
> copy
>
|||However I want this to be automatic every 3 hours the report server need to
have the same catalog as the Production Server.
What I can do to automate this process.
Thanks
Tanweer
"Hilary Cotter" wrote:

> oops, that went out prematurely. You could follow these steps every time you
> want your database synchronized -
> http://support.microsoft.com/default...b;en-us;240867
> Or you could use replication. If you use replication you will have to build
> your tables and full-text indexes in advance on the subscriber. Then in your
> article properties make sure you select the delete all data option.
> SQL 2005 replication will support this directly.
> --
> 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
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u$9GFtsaFHA.3488@.tk2msftngp13.phx.gbl...
> databasde
>
>
|||This can be automated.
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
"Tanweer" <Tanweer@.discussions.microsoft.com> wrote in message
news:0E2E76B8-B1FE-4A1E-BE73-D1C949A2AB6A@.microsoft.com...
> However I want this to be automatic every 3 hours the report server need
to[vbcol=seagreen]
> have the same catalog as the Production Server.
> What I can do to automate this process.
> Thanks
> Tanweer
> "Hilary Cotter" wrote:
you[vbcol=seagreen]
build[vbcol=seagreen]
your[vbcol=seagreen]
however my[vbcol=seagreen]
it[vbcol=seagreen]
exploring a[vbcol=seagreen]
and[vbcol=seagreen]