Re: DP 6.11 Slow MSSQL Restore (168 Views)
Reply
Regular Advisor
Lois Morrett
Posts: 108
Registered: ‎02-23-2009
Message 1 of 2 (172 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 asp.net and iis services are stopped before the restore takes place.

 

Please use plain text.
Honored Contributor
Sebastian.Koehler
Posts: 1,155
Registered: ‎02-27-2007
Message 2 of 2 (168 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.

Regards,
Sebastian
---
Assign a kudo to this post, if you find it useful.
Please use plain text.
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