Hello,
I have an environment where I have a DB "source" being published from server
"A" to a DB "destination" on server "B". The "distribution" database in on
server "A". The replication agents are running on server "A".
I have a downtime where no users or jobs will be running on the "source" DB.
My queries are:
1) Will my replication be impacted if I run a DBREINDEX command on the
indexes in the "source" DB.
2) Will my replication be impacted if I run a DBREINDEX command on the
indexes in the "destination" DB.
3) Do I need to disable replication to be able to run the DBREINDEX command
on the subscriber and publisher end?
4) What would be the ideal steps to do a DBREINDEX on both the publisher and
subscriber end.
Thank you for your responses.
Regards,
Salil.
The answer to all of these is no, however DBReindex is logged and your log
reader agent won't work as efficiently as it has more log to chew through.
Use indexdefrag instead as it is an online operation.
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
"Salil" <Salil@.discussions.microsoft.com> wrote in message
news:041E047F-D8C9-4BDF-A7BC-764365EDA489@.microsoft.com...
> Hello,
> I have an environment where I have a DB "source" being published from
server
> "A" to a DB "destination" on server "B". The "distribution" database in on
> server "A". The replication agents are running on server "A".
> I have a downtime where no users or jobs will be running on the "source"
DB.
> My queries are:
> 1) Will my replication be impacted if I run a DBREINDEX command on the
> indexes in the "source" DB.
> 2) Will my replication be impacted if I run a DBREINDEX command on the
> indexes in the "destination" DB.
> 3) Do I need to disable replication to be able to run the DBREINDEX
command
> on the subscriber and publisher end?
> 4) What would be the ideal steps to do a DBREINDEX on both the publisher
and
> subscriber end.
> Thank you for your responses.
> Regards,
> Salil.
|||Thanks very much for your response...
I am doing DBREINDEX because INDEXDEFRAG will not affect Extent
Fragmentation much and my indexes are badly in need of a rebuild.
"Hilary Cotter" wrote:
> The answer to all of these is no, however DBReindex is logged and your log
> reader agent won't work as efficiently as it has more log to chew through.
> Use indexdefrag instead as it is an online operation.
> --
> 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
> "Salil" <Salil@.discussions.microsoft.com> wrote in message
> news:041E047F-D8C9-4BDF-A7BC-764365EDA489@.microsoft.com...
> server
> DB.
> command
> and
>
>
)
