MaintenancePlan - Job works but there is no physical backup file on hard disk

Question

Hi

I have problem with maintenancePlan section. I have done one plan for backup and start the Agent service and even job works successfully but there is no backup file on harddisk. I tried many times that by deleting Plan and creating again but it didn't change also I restarted again both service of sql and again there was no change.

Finally, I saw log file viewer and there was an error that I mentioned that on the following points:

Executed as user: NT AUTHORITY\LOCAL SERVICE. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:17:09 AM  Error: 2013-01-27 10:17:09.42     Code: 0xC0017006     Source: MaintenancePlan      Description: The expression "LEN(@[global::RunId]) > 0" must evaluate to True or False. Change the expression to evaluate to a Boolean value.  End Error  Error: 2013-01-27 10:17:09.42     Code: 0xC0014021     Source: MaintenancePlan      Description: There was an error in the precedence constraint between "Subplan_1" and "Reporting Task for subplan-{6AA6970B-A978-4616-B527-4B92D54611A6}".  End Error  Could not execute package because of error 0x80004005.  Started:  10:17:09 AM  Finished: 10:17:09 AM  Elapsed:  0.156 seconds.  The package executed successfully.  The step succeeded.

My sql server version is 2008 and my Windows is seven. Unfortunately my effrots didn't solve the problem. I await your answer.

Thank you.

 

Answer 1

A maintenance plan or a job is running under NT AUTHORITY\LOCAL SERVICE which is probably does not have enough permission to store/create a bak file.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 2

What exactly are you implementing with this maintenance plan. From the message above, it looks like some condition failed in the plan..

---

Hope it Helps!!

Answer 3

Hi Alireza,

The Local Service account is a built-in account that has the same level of access to resources and objects as members of the Users group. This limited access helps safeguard the system if individual services or processes are compromised. Services that run as the Local Service account access network resources as a null session without credentials.

Be aware that the Local Service account is not supported for the SQL Server or SQL Server Agent services. The actual name of the account is "NT AUTHORITY\LOCAL SERVICE".

Selecting an Account for the SQL Server Agent Service: http://msdn.microsoft.com/en-us/library/ms191543(v=SQL.100).aspx.

Thanks.

---

Maggie Luo
TechNet Community Support

Answer 4

As per your error message, it seems to be a permission issue. For troubleshooting purpose, manually run the job script through SQL Server Management Studio.

If it is successful then verify your security context. If this job steps has a specified proxy then check permission for this security context. If job steps has no proxy then it is running with SQL Server Agent Service Account's security context then check permission for SQL Server Agent account.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

Answer 5

Thank you for your consideration. I try to solve this problem by changing the user of SQL Server service and SQL Agent Service but all of them don't work. So please help me what can I do to solve that.

Answer 6

Hello,

  what error message are you seeing this time?? 

---

Hope it Helps!!