SQL backup restore process speed up when using Restore-SqlDatabase

Question

Hi,Happy Easter and stay safe We do daily refresh SQL database from production using powershell Restore-SqlDatabase . I used following parameters to speed up the restore process DB size =1TB, time taken to restore 2hr 15 min. -MaxTransferSize 4194304 -BufferCount 1024 I increase buffercount from 64 to 1024 as no significant benefit . we need to reduce to 45 min . server specification =8cores /32GB memory. no other jobs run during restore any other option to speed up the process. I know cant use any parallelism Can any one advice would be great

Answer 1

Hi @Ashwan,

Here are some ideas for your reference:

Use multiple backup files: If you're using a single backup file for your restore operation, consider breaking it up into multiple smaller backup files. This can help speed up the restore process by allowing multiple restore threads to work on different backup files in parallel.

Place backup files and data files on separate disks: This can help improve I/O performance during the restore process by reducing contention between backup and data I/O.

Consider using compression: SQL Server provides the ability to compress backup files, which can reduce the size of the backup and the time it takes to transfer and restore it. However, this may also increase the CPU usage during the backup and restore operations.

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-compression-sql-server?view=sql-server-ver16

Hope these would give you some help.

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".