It is my SharePoint database that is causing this issue.

Jeffrey Williams (6/18/2009)

---

SQL Server has to roll back/forward all transactions that are hardened in the transaction log. Those transactions will be hardened after a transaction log backup is performed.

Since...

Also, I thought that by doing the backup on the transaction logs it would 'comit' those transactions hence not having to roll back/forward much.

no, since this was the fist backup ever on the Transaction Logs we did a manual one. We did...

Jeffrey Williams (6/18/2009)

---

How often do you backup your transaction logs? Why is the transaction log file 70GB and the database 30GB?

My guess is that you have a lot of...

so if we are talking about servers and software attributes would it be a good idea to have a 3rd table that has all the attributes that are common and...

that is exactly what I am talking about. How do you manage that or is it a matter of preference? At what point is it ok to have 'some' empty...