Slow SharePoint restores
I'm trying to formulate a disaster recovery plan for our SharePoint environment. So far the solution I have works, but the restores are extremely slow (150-200MB/min).
Here's my setup:
- SharePoint WSS 3.0 installed on a W2K3 VM
- SQL 2008 SP2 installed on a physical W2K3 box
- BackupExec 2010 R3 with SharePoint agent installed on physical 2008R2 box
And this is my DR plan:
- Recover VM using VRangerPro
- Install new SQL instance onto an existing Server (different to the live one when we're at our DR site)
- Create SharePoint and BackupExec SQL logins
- Restore Web Applications with the SQL redirected to the new SQL instance using the SharePoint Redirection options
- Restore Config DB - again redirected to new SQL instance
Now, this process does work, however step 4 takes forever! I have about 10 Content DBs in 1 web application - in total about 115GB. Backup Exec will restore the DBs back to the new SQL server with a Job Rate of 3GB/min but as soon as the byte count hits the expected size for that DB the job just seems to hang. Looking on the SQL Server the DB is in a '(Restoring)' state. If I leave it alone for longer enough the job eventually completes and the DB is restored, but I don't know what it is doing or trying to do for the majority of the job! The eventual Job Rate ends up at 200MB/min, meaning my 115GB restore takes around 10hrs to complete - not great.
I've tried many different options but nothing seems to make a difference.
Has anyone had a similar experience to this? if so I'd greatly appreciate your assistance.