question

naga avatar image
naga asked

Restore taking long

Restore of xyz database used to take 20-30mins but recently I enabled backup encryption and now the restore is taking few hours. Is this a expected behavior, if not what could be causing the slow restore?

databasebackuprestoreencryption
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

enterprisetoday avatar image
enterprisetoday answered

Your best bet is to monitor the restore computer during that process. Check cpu usage and the disk subsystem. Has the database size increased?

If you have spare hardware, or on your own dev machine, use a compressed and uncompressed backup file and get baseline timings for these.

Dallas

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

naga avatar image
naga answered

The size hasn't increased but I will try to monitor it the next time when I restore. Thank you!

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.