Reduce restore windows
We have bunch of databases whihc reside in a single server. Currently we have a decidated policy to back up around 2TB data, it will need 8 hours to back up and around 20 hours to restoe. We will need to tune the backup and restore, specially reduce the restore windows.
There are some ideas currently we are considering. If you have any other ideas, please let me know.
1. split the backup policy to two for using two LTO5 drives for backup and restore
2. use decidated volume pool to aviod mixing data with other backup policies with same retention (library are shared for multiple polices)
3. disable multiplexing to reduce restore time
4. exclude out all file system and log files form database policies
.......
thanks in advance
After some testing, we find a way to satify our request.
1. turn off MPLX and multi-streams (for better restore performance)
2. larger the fragment size (for better backup/restore performance)
3. direct backup to two storage units which point to same library to force backup to use two tapes
4. separate all unnessary data to different policy and use different storage unit
5. split backup to two policies, each back up half data
the changes made big diffeence (backup time reduced from 9 hours to 3, restore time from 15 hours to 3)