filestream restore very slow to DR server

Posted by Jim on Server Fault See other posts from Server Fault or by Jim
Published on 2012-06-04T08:30:48Z Indexed on 2012/06/04 10:44 UTC
Read the original article Hit count: 1578

Filed under:
|
|

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.

© Server Fault or respective owner

Related posts about sql-server

Related posts about restore