What are the challenges you face when working across database platforms? Take the survey

Creating Images from TDE bak files, slow creation times

We just started to create SQL Clone Images from TDE backup files, it is creating images, but is taking considerably longer than before.  What can we do to speed up the image creation time?

 Our current settings are as follows:

$ImageOperation = New-SqlCloneImage -Name "Image_Daily" `

    -SqlServerInstance $SqlServer `

    -BackupFileName @('\\sharedrive\Backups\Database.BAK') `

    -Destination $ImageDestination

    -BufferCount 3000

    -MaxTransferSize 4194304

Thanks In Advance




  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Hi @johngrindel,

    Unfortunately SQL Clone doesn't have much involvement in this process beyond kicking it off.  All our process does it initiate the restore of the backup onto the SQL Server, but instead of the database files going into the default folder, they are created in a vhd mount point that ends up in the final image destination.

    The performance of the action will be based on the performance of SQL Server doing the restore and the speed of the network and disk writing to the image destination.

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.