2 deleted 82 characters in body; edited tags; edited title
source | link

Can you remove the redirect from Sql 2012 transtransactional replication from an HADR publisher?

We have a pair Sqlof SQL Server 2012 availability groups that we have set up transactional replication to a Sql 2012 distributor and subscriber.

We are moving databases for the (synchronized) secondary nodes to new faster less congested hard drives. Since these secondaries are synchronized, the transactions never commit and replication doesn't happen.

According to the BOL sp_redirect_publishersp_redirect_publisher should be used if the replica on the primary is taken offline. However it doesn't appear to have a scenario quite like what I'm looking for.

Has anyone had to move database files of an AG database to new drive media while that db was being published? If so what steps did you take?

Any assistance is appreciated. Have a great day. Richard L. Dawson Manager IS

Can you remove the redirect from Sql 2012 trans replication from an HADR publisher?

We have a pair Sql Server 2012 availability groups that we have set up transactional replication to a Sql 2012 distributor and subscriber.

We are moving databases for the (synchronized) secondary nodes to new faster less congested hard drives. Since these secondaries are synchronized the transactions never commit and replication doesn't happen.

According to the BOL sp_redirect_publisher should be used if the replica on the primary is taken offline. However it doesn't appear to have a scenario quite like what I'm looking for.

Has anyone had to move database files of an AG database to new drive media while that db was being published? If so what steps did you take?

Any assistance is appreciated. Have a great day. Richard L. Dawson Manager IS

Can you remove the redirect from transactional replication from an HADR publisher?

We have a pair of SQL Server 2012 availability groups that we have set up transactional replication to a 2012 distributor and subscriber.

We are moving databases for the (synchronized) secondary nodes to new faster less congested hard drives. Since these secondaries are synchronized, the transactions never commit and replication doesn't happen.

According to the BOL sp_redirect_publisher should be used if the replica on the primary is taken offline. However it doesn't appear to have a scenario quite like what I'm looking for.

Has anyone had to move database files of an AG database to new drive media while that db was being published? If so what steps did you take?

1
source | link

Can you remove the redirect from Sql 2012 trans replication from an HADR publisher?

We have a pair Sql Server 2012 availability groups that we have set up transactional replication to a Sql 2012 distributor and subscriber.

We are moving databases for the (synchronized) secondary nodes to new faster less congested hard drives. Since these secondaries are synchronized the transactions never commit and replication doesn't happen.

According to the BOL sp_redirect_publisher should be used if the replica on the primary is taken offline. However it doesn't appear to have a scenario quite like what I'm looking for.

Has anyone had to move database files of an AG database to new drive media while that db was being published? If so what steps did you take?

Any assistance is appreciated. Have a great day. Richard L. Dawson Manager IS