Re: DP 6.11 Slow MSSQL Restore (263 Views)
Regular Advisor
Posts: 108
Registered: ‎02-23-2009
Message 1 of 2 (267 Views)

DP 6.11 Slow MSSQL Restore

Every night I backup and restore a sql database from a core server to the dmz for external users to access. The backup of the database is running excellent (1.5 hours for 177 gig of data) but the restore is running for 6 hours at night.


Cell manager is 2008 R2

Media Agent is 2008 Standard

DMZ server is 2003 R2 with SQL 2005


Any ideas on how to speed up this restore? The backup is done to my VLS and as soon as the backup is finished the restore starts from the VLS to the DMZ server. The and iis services are stopped before the restore takes place.


Honored Contributor
Posts: 1,157
Registered: ‎02-27-2007
Message 2 of 2 (263 Views)

Re: DP 6.11 Slow MSSQL Restore

I'm curious. If you say the restore target is located in a DMZ, this makes me think of at least a single firewall between media agent and disk agent. Am I right? If this is the case, I would encourage you to place a media agent inside the DMZ to have direct restore performance by bypassing the firewalls completely.

Assign a kudo to this post, if you find it useful.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.