<div>
thanks for the post, all the tips were helped.
</div>


thanks for the post, all the tips were helped.

<div>
Valid recommendations and author said he got the solutions from the comments
</div>


Valid recommendations and author said he got the solutions from the comments

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We are currently having an issue with SQL replication, we have source database replication has been setup to a another database.<br />
It is transaction replication, it was running with a AD account, recently the user has left the organization, and replication has been stopped.<br />
<br />
Later on we fix the user issue by adding a service account on it, it has started the process and after few time the replication has been stopped. but Spotlight and SQL replication monitor show the replication happening.<br />
<br />
But actual data table does not sync with new data from the source.<br />
<br />
is anyone had the problem like this or any help to resolve this?
</div>
</div>


Hi,

We are currently having an issue with SQL replication, we have source database replication has been setup to a another database.
It is transaction replication, it was running with a AD account, recently the user has left the organization, and replication has been stopped.

Later on we fix the user issue by adding a service account on it, it has started the process and after few time the replication has been stopped. but Spotlight and SQL replication monitor show the replication happening.

But actual data table does not sync with new data from the source.

is anyone had the problem like this or any help to resolve this?

SQL 2012 replication monitoring showing that it is running, but actually replication not happening

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.