How to speed up the restore when backup was multiplexed?
We have a very large backup environment so we enabled multiplex data stream to make the backup run faster. But when we do the restore, it hangs forever if we need to restore the top directory at one time. We have to drill down to the subdirectories to split them and restore one ot two subdirectories at a time. That will work. I am just wondering is there any way to make the restore faster. I read some posts from this forum, it suggests to modify the value of MPX_RESTORE_DELAY. The default is 30. How do I know what's the proper value for my environment? Do you have any experience with this? Thanks in advance for your help!