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.
Cheers,


Edwin de Jonge
MS SQL Server Engineer
The Learning Network
+31612119999
Tagged:

Answers

  • 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.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • 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.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • 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.
    Cheers,


    Edwin de Jonge
    MS SQL Server Engineer
    The Learning Network
    +31612119999
  • 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.
    Cheers,


    Edwin de Jonge
    MS SQL Server Engineer
    The Learning Network
    +31612119999
Sign In or Register to comment.