Tried re-installing Windows Server SP 2 yesterday after the restore and re-booted the server, still had the same problem, I suppose the extreme would be to stop the server, cut...

I don't whether this will help but have you tried this sql cumulative fix:

http://support.microsoft.com/kb/933097

I have the same issue, I did a Disaster Recovery of a Client server and...

I have used this script on a 176GB file (Database & Log file) which reduced to 100MB in approx 20 minutes, after backup. Just remember to put in the name...

Fragmented indexes slow down your SQL Servers and keep your clients waiting, not good for a business. Using DBCC SHOWCONTIG to create your trend analysis is time-consuming and slow. ...

I had the same problem with 2 log files, one was 40GB the other was a staggering 176GB, I found a script that I ran over the 2 log files,...