Does anyone know how to write a sql script that would display how much data (active version only) would be restored for a volume/drive? I am looking for a way to determine how long a restore will take based upon the amount of data that needs to be restored.
