<div>
Yes you can use Merge Snap shot for REplication. In that both server instance are ready to use and updated.
</div>


Yes you can use Merge Snap shot for REplication. In that both server instance are ready to use and updated.

<div>
<div class="content wysiwyg-content">
Background:<br />
<br />
I set up a MSSQL Transactional Replication DB is replicated from <br />
-Primary Server instance1 (MSSQL2008 R2) to Secondary Server instance1 (MSSQL2008 R2)<br />
<br />
Transaction Replication is working good for Pri to Sec.<br />
I would like to simulate the case of changing over using Secondary Server instead of primary Server.<br />
<br />
Then, <br />
1. i cleaned up any Replication on both server.<br />
2. Use Sec Server instance1 as Publication &amp;&nbsp;Distribution &amp;&nbsp;Pri Server Instance1 as Subscribe.<br />
<br />
-It is noticed that there is error after reverse the transactional replication using the original DBs.<br />
-If i completely delete the Pri Server instance1 &amp;&nbsp;Let the Sec Server instance1 create a &quot;new DB instance2&quot; on the Pri Side, the transactional replication started ok.<br />
<br />
MY Question is <br />
Could i use the original DBs (Pri Server Instance1 &amp;&nbsp;Sec Server instance1) when i reverse the direction of the replication.<br />
If it is possible-&gt; how do i solve the issue.<br />
<br />
Expert please help.
</div>
</div>


Background:

I set up a MSSQL Transactional Replication DB is replicated from 
-Primary Server instance1 (MSSQL2008 R2) to Secondary Server instance1 (MSSQL2008 R2)

Transaction Replication is working good for Pri to Sec.
I would like to simulate the case of changing over using Secondary Server instead of primary Server.

Then, 
1. i cleaned up any Replication on both server.
2. Use Sec Server instance1 as Publication & Distribution & Pri Server Instance1 as Subscribe.

-It is noticed that there is error after reverse the transactional replication using the original DBs.
-If i completely delete the Pri Server instance1 & Let the Sec Server instance1 create a "new DB instance2" on the Pri Side, the transactional replication started ok.

MY Question is 
Could i use the original DBs (Pri Server Instance1 & Sec Server instance1) when i reverse the direction of the replication.
If it is possible-> how do i solve the issue.

Expert please help.

Could i Reverse the MSSQL Transactional Replication from Secondary DB to Primary?

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 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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.