Replication does detect Mirrored Source Fail Over

I'm trying setup a proof of concept for a client but I’m having issues with mirroring and replication.

With the help of http://technet.microsoft.com/en-us/library/ms151799.aspx I’ve done the following..

The setup is as follows, I have several instances of SQL Server

A+B are mirrored with each other, with A being the principle and B the mirror

C is the distributor

E is subscribes to A, with parameters for PublicationFailoverPartner set to B

The mirroring between A+B works fine, I can manually fail each and the databases keep in step.

Without testing the mirroring failover, the replication between A+C+E also works.

However when I test the mirror to failover between A+B no transactions are replicated though to E. The publication moves from A to B in the Server Management Studio.

The logs state that the log reader agent can not gain access to A, however nothing is recorded regarding any attempts to contact B. In the replication monitor the error message

"The concurrent snapshot for publication ABCXYZ is not available because it has not been fully generated of the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Spapshot Agent for the publica..." (cut off).

"the process could not execute 'sp_replcmds' on 'A'

I have checked that the SQL Server Agents are running on all agents,

I have checked that that server B is set at the PublisherFailoverPartner on server C agent configuration, I'm now at a lost as to what is wrong,

Any help or suggestions are greatly appreciated.

Pls do not duplicate

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1958649&SiteID=1

|||

Sorry about this Deepak, I had duplicated this as I though I had lost my original post, it was just in anothor forum,

appologies for being a Topic Hog

Replication concept

Hi,
I got a new application with Access front end and sql server back-end. This
application has replication features where users can directly upload their
changes on the main server. I have no knowledge about replication. However, I
need to maintain this sytem. Is there any article or book that will help me
achieve this? Please let me know. Thanks in advance.
Are you sure that this is being replicated? If users are sending their access
changes to sql server, it sounds like this might be the way that the Access
application is designed, and not SQL Server replication. If it is somehow SQL
Server Replication, then there are 2 books out there (see
www.replicationanswers.com for links on homepage) and books on line (BOL).
Cheers,
Paul Ibison
|||Thanks Paul for your advise. I appreciate it.
Best Regards,
"Paul Ibison" wrote:

> Are you sure that this is being replicated? If users are sending their access
> changes to sql server, it sounds like this might be the way that the Access
> application is designed, and not SQL Server replication. If it is somehow SQL
> Server Replication, then there are 2 books out there (see
> www.replicationanswers.com for links on homepage) and books on line (BOL).
> Cheers,
> Paul Ibison
>
|||Hope the books help, but I'd check first of all verify that you do have
replication occurring. It's possible that heterogenous subscribers have been
configured so your Access database is a subscriber to a SQL Server publisher,
and the uploading of changes in Access is a triggering of the synchronization
process (starting the ActiveX control to merge a pull subscription). Having a
look at the SQL Server box should show if this is the case and if so, looking
for heterogenous subscribers in BOL should help.
Paul Ibison
|||I would check to see if they have linked tables or if they have code in the
access project to write to SQL Server.
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
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:2F158A54-ACE0-4C5B-913E-AD13C89DEF19@.microsoft.com...
> Hi,
> I got a new application with Access front end and sql server back-end.
> This
> application has replication features where users can directly upload their
> changes on the main server. I have no knowledge about replication.
> However, I
> need to maintain this sytem. Is there any article or book that will help
> me
> achieve this? Please let me know. Thanks in advance.
>

replication

What is meant by replication? where should we use this concept? please give me valuble informationThis is useful for yooer reference

http://databases.about.com/cs/sqlserver/a/aa041303a.htm|||Thankyou very much for this link Mr.vssp|||Thanks vinod