Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

How to confirm sycronization between primary DB and secondary DB

How can i confirm that my primary DB and secondary DB are properly syncing?
  • 3
1 Solution
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
if you are only concerned with record counts, you can
1) create a script that will do counts of each table in both databases and compare the counts.

if you have a modified date in the rows of a table, you can select the max(modified_date) from each table and compare as well.
Jagdish DevakuSr DB ArchitectCommented:
U can also check them third party tools

apex sql diff

sql delta (recommended)

Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
yes, redgate has some good db comparison as well.
funnymanmikeAuthor Commented:
so nothing internal to sql? do data comparison in general or error log?
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
On your server, in SQL Server mgmt studio you can right click on Replication (TRee view under your database). View the local publications and right click on the publication items you are interested in...from there you have several options, but one is to "View REplication Status". Select that to see the current or latest replication status.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now