Hello.

I am restoring ServiceDesk Plus, database only, in my DR environment using restoredata.bat and it is taking 9 hours to complete.  The SQL process is using 100% CPU at the time.  The database is only 14GB in size.

Additionally, it generates a 50GB transaction log during the process.

Can anyone help reduce this restore time, and also the transaction log size (I have already set the recovery mode to simple).  I suppose I could restrict the size to 5GB or 10GB if no better suggestions are available.

Details:
ServiceDesk Plus version: 9.0 build 9027
SQL version: Microsoft SQL Server 2008 R2
Operating System: Windows 2008 R2
Memory: 4GB (SQL instance capped at 2GB)

Thanks in advance,

Dave