Gary Harper
asked on
SQL Maintenance Plan runs successfully but files not backed up to folder
I have a SQL Server 2005 SP4 instance. When creating maintenance plans to back up the user and system databases they run successfully in less than 5 seconds. Of course the databases are not backed up but the jobs ran successfully as far as SQL is concerned. If I backup the databases manually it works without issue. I have uninstalled and reinstalled the SQL client tools and integration services on this server and still have the same issue. Any ideas? Please advise.
Any errors or otherwise helpful info in the error log for the sql agent job associated with the maintenance plan?
ASKER
Checking the reporting and logging I do see the error message
"2013-09-20 11:07:10 - ! [382] Logon to server 'E2PBLD01' failed (ConnAttemptCachableOp)"
How is that possible even though I am connected?
"2013-09-20 11:07:10 - ! [382] Logon to server 'E2PBLD01' failed (ConnAttemptCachableOp)"
How is that possible even though I am connected?
Check the connection settings on your maintenance plan.
Can you post a snapshot of the connection that the SSIS package is using as well as check what service account IS and/or SQL Server Agent are running as? (when you open the maintenance plan, it will be in Manage Connections...) If it's trying to access a remote machine and the integration services account is installed as a local system account that would present an issue and also check the effective permissions of the SQL Server Agent's service account if it's a local connection.
ASKER
When going back to check the maintenance plan I now get the message
"Microsoft SQL Server Management Studio is unable to load this document. The LoadFromSQLServer method has encountered OLE DB error code 0x80004005"
I have reinstalled client tools and integration services. Is it possible something is inherently wrong with the SQL installation?
"Microsoft SQL Server Management Studio is unable to load this document. The LoadFromSQLServer method has encountered OLE DB error code 0x80004005"
I have reinstalled client tools and integration services. Is it possible something is inherently wrong with the SQL installation?
login as another windows user and try to load the plan
ASKER
It allows me to run it successfully. However it only takes 2 seconds to run and checking the maintenance plan log I get the same error:
"2013-09-20 15:16:10 - ! [382] Logon to server 'E2PBLD01' failed (ConnAttemptCachableOp)"
Any ideas?
"2013-09-20 15:16:10 - ! [382] Logon to server 'E2PBLD01' failed (ConnAttemptCachableOp)"
Any ideas?
Open the maintenance plan, make a new connection, manually enter login info and save it. then run it
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Using SSMS, double click on your Maintenance Plan in the Object Explorer. In the Object Explorer Details, click on the "Reporting and Loging" icon (close to the "Manage Connections" button). Go to that path, and find the log file