| Author |
Log shipping and Full Text
|
|
| Tanweer 2005-06-06, 8:24 pm |
| 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 2005-06-06, 8:24 pm |
|
--
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@microso
ft.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
| |
| Hilary Cotter 2005-06-06, 8:24 pm |
| oops, that went out prematurely. You could follow these steps every time you
want your database synchronized -
http://support.microsoft.com/defaul...kb;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...
>
>
> --
> 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@microso
ft.com...
> Replication
> saying
databasde[color=dark
red]
> is
> copy
>
>
| |
| Tanweer 2005-06-06, 8:24 pm |
| 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/defaul...kb;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
>
>
>
| |
| Hilary Cotter 2005-06-06, 8:24 pm |
| 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@microso
ft.com...
> However I want this to be automatic every 3 hours the report server need
to[color=darkred]
> have the same catalog as the Production Server.
> What I can do to automate this process.
>
> Thanks
> Tanweer
>
> "Hilary Cotter" wrote:
>
you[color=darkred]
build[color=darkred]
your[color=darkred]
however my[color=darkred]
it[color=darkred]
exploring a[color=darkred]
and[color=darkred]
|
|
|
|