Thanks! I was able to solve this by taking database offline then immediately bringing it back online.

Replicate data for Reporting needs(not the entire database couple of tables from different databases). Secondary Sync node is for offloading the maintenance.

Thanks! It make sense.

Actually it's not a SQL server reporting tool, it is another reporting tool. For e.g. when running the query directly on SQL Server it runs in 1 min and from...

Thank you. I see the record type as Login timers and record time using the link you sent. Where would i see if there is any connectivity issue? I will...

Thanks! There is a ETL Process which connects to my SQL server replicated database and the ETL jobs started failing and the ETL team thinks this could be connection issue...

Thanks! I have few more questions , with replication there are limitation that tables with primary key are qualified to replicate and configure. So what if the tables does not...

Thanks sue and steve. This is very good information, i really appreciate it.

I have clustered indexes on subscriber and the user has some reports running directly against subscriber database and...

Are these Unsupported features & services. are still unsupported? Since this thread seems to be a last year, do you think there are any additional pros? Has any other benefits...

Since i have some of the huge tables on publisher, so i didn't enable snapshot to happen once every day. I think it make sense otherwise the copy would take...

So you saying configuring mirroring secondary as higher version is possible. Will there be any setup issues or any other issues noticed?

I would think that you have to upgrade the database first to SQL 2014 and then reconfigure the replication after the upgrade. It should be that hard to reconfigure the...

Sorry not sure why i said service accounts. I mean to say Logins and user permissions.

Sorry i wasn't clear. I meant to say every time a new server gets built or database is added to the instance. I add the account's manually instead i would...

Thanks! So you saying i can configure mirroring from SQL 2012(primary) to SQL 2014 or SQL 2016(mirrored database)? Also, another question does SQL 2012 can be installed on Windows 2016...