Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maintenance Backup Plan Failing Sporadically - Failed to acquire connection "Local server connection". Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 9:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:25 PM
Points: 16, Visits: 143
Occasionally I'm seeing the following error when tranlog or full backup maintenance plan is executing.

Failed-1073573396) Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection.

What is strange is that it goes away without any action from myself. We have a tranlog backup that is scheduled every hour. I had this error happen once in the middle of the night. It looks like the job was running fine because almost all the backups are there. I've searched and not found a resolution to this error. I checked the event log and don't see any issues and even tried rebuilding the maintenance plans. Any help is appreciated.
Post #1567556
Posted Monday, May 5, 2014 10:26 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 15,516, Visits: 27,892
That's usually an indication of one of two things, the login running the job, whatever it might be, doesn't have access to the server, or, it has the server connection configured wrong. Are you sure you don't have other jobs that are failing instead of one job failing on an intermittent fashion? Are there other automated processes that might interfere?

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1567611
Posted Monday, May 5, 2014 11:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:25 PM
Points: 16, Visits: 143
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.
Post #1567645
Posted Monday, May 5, 2014 12:02 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 15,516, Visits: 27,892
Are there two different servers involved? Are you in a failover situation or something along those lines? It could be that it was failed over during that period.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1567657
Posted Monday, May 5, 2014 2:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 7:25 PM
Points: 16, Visits: 143
It is a standalone server. No failover.
Post #1567714
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse