I've never faced this issue before. Please make sure that the integration services and the SQL Agent are using the same service account.

One can view the Trigger definitions by querying syscomments view.

You can sys.objects to get all the triggers.

I didn't see backup compression mentioned before, assuming you're already using it.

Use Backup file Striping with the methods described in the below blog. I could reduce to backup times from few hours to with in an hour for large databases.

This link may be useful, perhaps the problem is already resolved.

http://msdn.microsoft.com/en-us/library/ms189580(v=sql.105).aspx

I don't know how the SQL Agent job is set-up. If it is using a Stored Procedure to backup all databases, you should look at the logic of that SP....

What the SQL Server agent job does? It could missing indexes if DELETE/UPDATE is being performed.

You can use SYSTEM_USER function in SQL Server. Please refer to the below link.

http://msdn.microsoft.com/en-us/library/ms179930.aspx

You might want to check available space on the index/data drive. Reindex (not rebuild) needs space as it is an online operation. You might want to check the log space...

I have had checkpoint process running into hours after nightly restores of some reporting databases. We figured that the issue was related to disk performance and it had to be...

Open a new query in the database that you are interested in increasig the file-size and run the below query.

SELECT * FROM SYS.SYSFILES

Select the "Name" with groupid = 0

Run the...