Home Forums SQL Server 2008 SQL Server 2008 - General Maintenance Backup Plan Failing Sporadically - Failed to acquire connection "Local server connection". RE: Maintenance Backup Plan Failing Sporadically - Failed to acquire connection "Local server connection".

  • The only 2 jobs that have failed are tranlog backup and full back. Reindex, statistics, and integrity check all ran without errors. The tranlog backup has only failed once in a week and it had that error. That job runs every hour so there are numerous accounts of it running without any issues. The backup failed the same day the tranlog did and that was the only time in 7 days it failed. It appears something happened that day but an hour later the tranlog job was running fine.