Last post Dec 23, 2014 11:11 AM by zoggling
Dec 22, 2014 08:14 AM|zoggling|LINK
We have a database which is (a subset of tables are) replicated to another via transactional replication. Whilst most changes made at the published database reach the subscriber within a matter of seconds, we have a SQL Agent job which performs a calculation
in the published database and then immediately exports data from the subscriber using log shipping. The result is that the calculated changes do not make it through to the exported transaction logs in time.
Is there a way to manually "refresh" the subscriber databases using T-SQL?
Dec 22, 2014 09:35 PM|Edwin Guru Singh|LINK
As per my understanding of your case, the following link will be guide to solve your issues :
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore,
Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you
completely understand the risk before retrieving any software from the Internet.
Hopefully this will be helpful for you.
Dec 23, 2014 11:11 AM|zoggling|LINK
Correct me if I am wrong, but this link is regarding backups/restores rather than transactional replication... As such, it doesn't solve our problem unfortunately.