I have set-up FileStream for 1 500 GB database on primary server. 99% Space is occupied by Filstream(blob) data.
I am doing backup from primary server and restore to Secondary server daily. couple of days before restore command use to take 5-6 hrs to complete which now taking almost 16-18 hours.
I am not sure what's wrong here but i checked to perform restore on another 2 servers using backup from primary server and it's taking 16-18 hours their as well.
i am using litespeed for backup and restore.
Do i need to improve my backup and restore job command??
Stripped backup will restore faster or only file restore will perform faster because of filestream??
Any Advise will be appriciate 🙂