Query to get status of log-shipping

  • We have custom log-shipping, i can easily find the time stamp when the t-log backup was taken and when the log was restored. As an additional check i thought i could take first and last lsns from source database and match it against first and last lsn's of target database. Apparently the lsn's match ( i.e source firstlsn = target first lsn and same for last lsn ) how ever in reality target database is 60 mins behind. Am i checking against wrong LSN's?

  • Are both servers in the same time zone?

  • Yes.

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

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