how to find out last refresh date

  • Hi all,

    We're using SAN level replication to create a copy of production on daily basis.

    Is there a way find out the last refresh time using sql/tsql?

    Thanks,

  • SAN level replication should be creating a binary copy of the database files and log files. Which means all T-SQL should return the exact same results on the replica as the production database. You need to consult your SAN replication's documentation. Perhaps it exposes an API that harnesses OLEDB, in which case a linked server to the SAN's replication functionality could be harnessed in T-SQL. Otherwise you must use whatever the SAN's API exposes.

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

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