September 10, 2009 at 7:50 am
Hi,
As part of our MP in one of our instances we have a transaction log backup that runs every hour on the hour. That job runs fine almost all the time, but some days if fails with the message below. It only fails on the mid-night run, and is not every day. There are no other jobs running at that time, and nothing changes on the MP.
This is a SQL Server 2005 x64 09.00.3186 running on a clustered environment, and the SQL Agent is running using a domain account.
Any ideas?
Started: 12:00:01 AM
Error: 2009-09-10 00:03:05.64
Code: 0xC00291EC
Source: Back Up Database Task Execute SQL Task
Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:00:01 AM
Finished: 12:03:09 AM
Elapsed: 188.235 seconds
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
September 10, 2009 at 8:03 am
Filipe Miranda (9/10/2009)
Hi,As part of our MP in one of our instances we have a transaction log backup that runs every hour on the hour. That job runs fine almost all the time, but some days if fails with the message below. It only fails on the mid-night run, and is not every day. There are no other jobs running at that time, and nothing changes on the MP.
This is a SQL Server 2005 x64 09.00.3186 running on a clustered environment, and the SQL Agent is running using a domain account.
Any ideas?
Started: 12:00:01 AM
Error: 2009-09-10 00:03:05.64
Code: 0xC00291EC
Source: Back Up Database Task Execute SQL Task
Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:00:01 AM
Finished: 12:03:09 AM
Elapsed: 188.235 seconds
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
normally this error can mean a permissions issue with the account that is running the job, however if it is working most of the time.
I would look at the windows event logs to see if there was any network issues or anything else reported for that time it failed.
depending on what logging/auditing you have in place. check to see if there are any failed logins for that time as well.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply