Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

3945

June 29th, 2016 02:00

MSSQL Restore runs very slowly

Hello all.

I am starting with info:

Networker server 8.0 (OS win2008R2) physical

Networker client 8.0  (OS win2003 Enterprise) virtual

Networker module for MSSQL 5.2  (MSSQL 2005)

The backup is running through 10Gb ethernet

The full backup of MSSQL (db size 7,2TB) took about 5 hours with 16 stripes in 2 LTO4 tapes (throughput was about 450Mbps).

I am running the restore to another server (through a 10Gb ethernet) and the throughput is 30Mbps.

I understand that stripping the backup has an impact at restore but the difference is very big.

Does anyone has an idea how to speed up the restore procedure with the current settings?

Thank you in advanced

No Responses!
No Events found!

Top