Hi,
let's say if i need to replicate a huge database to another server ,
where/how could i check how much % of data has been replicated over
tks & rdgs
If you are talking about the initial snapshot, then you can keep refreshing
the history of the distribution agent, as it shows the number of batches it
applied to the subscriber, along with the number of rows/batch. If know how
many rows there are on the publishing table, then the distribution agent
history gives you a pretty good idea of how many more rows to go.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:C637A6F1-5060-4247-8F63-FABA4FC5B33D@.microsoft.com...
Hi,
let's say if i need to replicate a huge database to another server ,
where/how could i check how much % of data has been replicated over
tks & rdgs
Tuesday, February 14, 2012
checkign replication percentage
Labels:
checkign,
database,
huge,
microsoft,
mysql,
oracle,
overtks,
percentage,
replicate,
replicated,
replication,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment