• This is sort of on topic but not.

    By running this command you will see how fragmented the transaction log is. It is very important to have as few extends as possible. I have found several of mine in well over 1,000 fragments. To fix this I simply shrunk the trans log to 100MB then grew it by the size it should be and set a good size for growth.

    I know this won't help you with data file .mdf issues but the trans log is important as well.