Monday, March 12, 2012

How long it take to finish replicate data

I have a database A include five tables, and have more than 1,500,000 rows. There is a replica database of A. First of all, there is no data in the two dbs. When I finish inserting data into A, the replica db seems still work, the log file size still changes. How can I know the replication finished or not? How long it will take to finish replicate 1,500,000 rows of data?Is this transactional replication or merge? If it is transactional you can use select * from distribution.dbo.msdistribution_status to determine how many of the rows have been replicated.

No comments:

Post a Comment