Creating Images from TDE bak files, slow creation times

johngrindeljohngrindel Posts: 1 New member
in SQL Clone

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:
· Share on Twitter

Answers

  • Alex BAlex B Posts: 1,157 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,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
Sign In or Register to comment.