There is a fix for this Maintenance Plan bug.

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

If you're interested in a script, I have a stored procedure that you can use to check the integrity of all your...

Have you considered doing your sql server backups to disk? I think this is better from an reliability and performance point of view. (This means that you would have to...

I think that you should avoid shrinking, not only the transaction log, but also the database.

Paul Randal wrote about this in his blog some time ago.

http://www.sqlskills.com/blogs/paul/2007/11/13/AutoshrinkTurnItOFF.aspx

About recovery models and transaction...

I have a stored procedure that you can use if you like.

EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory = 'C:\Backup', @BackupType = 'FULL', @verify = 'Y', @CleanupTime = 24

Here it does...

Could it be anything with antivirus or backup software that is locking the file?

Ola Hallengren

http://ola.hallengren.com

In case you would go for the index-level option I have a stored procedure that might be helpful. (It could be that you have to keep the tables online and...