SQL Server Performance Forum – Threads Archive
How to find out refresh date?
Is there anyway we can find out when the data refresh was done? I have a replication server which is refreshed from production but do not know the schedule. So, is there any other way to find this out besides asking OPS DBA team? Thanks in advance for your input. Thanks,
Never mind, I could find the latest refresh date using Management Studio(or Enterprise Manager) but not the frequency though. Thanks,
I beleive frequency information is nothing but job schedule.
Check the underlying job schedule. Mohammed.