filestream restore very slow to DR server
- by Jim
We are backing up a database containing 100GB of filestream data.
The backup takes under two hours to write.
Restoring the same database to the DR environment is taking over forty hours.
We don't have the same problem with other (non-filestream) databases, including some that are much larger.
How do we try and get to the bottom of the problem.
The database is in full recovery mode, and we are doing a full backup.
Thanks.