05-14-2012 08:56 AM
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.
05-14-2012 09:36 AM
Assign a kudo to this post, if you find it useful.