Post reply

query to check time taken by snap shot replication to transfer data

  • April 11, 2014 at 4:04 am

    #306690

    Hi friends,

    Let us assume, I have created snapshot replication from Server A to Server B for transferring data at 5 AM. Is there a way to find how many mins it has taken to complete data transfer?

    Thanks in advance..

  • April 11, 2014 at 9:11 am

    #1705363

    Can't you look at the Snapshot Agent job? There should be Duration column.

    --Vadim R.

  • April 11, 2014 at 9:12 am

    #1705365

    I don't believe this is possible other than watching the snapshot run via the GUI, you can however determine the total size of the snapshot. Then, based on your network speeds, make an educated guess?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • April 11, 2014 at 9:49 am

    #1705387

    Should be in the job history (under SQL Server Agent if you use Object Explorer).

    Or check here: msdb.dbo.sysjobhistory

    --Vadim R.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply