Expand image dashboard with more or latest restored file(s)

EdwinDeJonge

Hi,

I'm cloning production databases based on striped FULL and DIFF backup files.
As far as I know I'm not able to see which .bak file was applied latest when creating the image.
If I click on a an image on the main dashboard page, I can see the filename of the first backup filename where the clone was restored from.

In my case, I clone databases from 8 striped FULL backup files along with 8 striped DIFF backup files, so 16 files in total.
At this point in time I'm not able to "prove" or check if the clone is actually created with all of these 16 files, let alone if the last DIFF file was applied to the restore.

I'd like to see all of the files that where used during the entire cloning process on the image dashboard page.
If our developers check the dashboard, they think the clone is running behind a full day ...
It would be nice if this could be expanded in one of the upcoming releases.

Tianjiao_Li

Thanks for raising this with us!

I can see you point and will run this past the development team.

I'll update you shortly with their input.

Thanks.

Tianjiao_Li

It's possible to get it in Powershell by:

$image = Get-SqlCloneImage "MyImage"<br>$image.BackupFilenames

We actually have the data in the Web UI, but it's not displayed at the moment. The team will need further investigation on how to best displaying it. In the meanwhile, hopefully using the Powershell will give you the confirmation you are after.

Thanks.

EdwinDeJonge

Hi

The only thing I get to choose from the variables properties are:

Name

CreatedBy

CreatedDate

CreatedDateUtc

State

SizeInBytes

OriginDatabaseName

OriginServerName

Id

Unfortunately no such thing as backupfilenames.

EdwinDeJonge

Nevermind ...

Just to be sure, I downloaded the latest cmdlets of which I thought were being automatically updated when I install a new version of SQLClone ...

Would still be nice to have in the WEBUI though.