How can we help you today? How can we help you today?

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

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.
EdwinDeJonge
0

Comments

4 comments

Sort by
  • 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
    0
  • 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.
    Tianjiao_Li
    0
  • 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
    0
  • 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.
    EdwinDeJonge
    0

Add comment

Please sign in to leave a comment.