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

John

Tagged:

Answers

  • 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,
    Alex
    Product Support Engineer | Redgate Software

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