locked
Code: 0xC002F210 Source: Execute T-SQL Statement Task Execute SQL Task RRS feed

  • Question

  • Executed as user: G-RPTG\backupdb. ...on 9.00.3042.00 for 32-bit  
    Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    
    Started:  12:53:38 PM  Error: 2012-09-25 12:53:38.56     Code: 0xC002F210     
    Source: Execute T-SQL Statement Task Execute SQL Task     
    Description: Executing the query "backup log AgentDesktop with 
    truncate_only  dbcc shrinkfile(AgentDesktop_Wipro_log,100)  
    " failed with the following error: "Could not locate file 
    'AgentDesktop_Wipro_log' for database 'master' in sys.database_files. 
    The file either does not exist, or was dropped. ". Possible failure reasons: 
    Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, 
    or connection not established correctly.  End Error  Error: 2012-09-25 12:53:38.59     
    Code: 0xC002F210     Source: Execute T-SQL Statement Task Execute SQL Task     
    Description: Executing the query "backup log BracBankIVRDB with truncate_only  
    dbcc shrinkfile(BracBankIVRDB_log,100)...  
    The package execution fa...  The step failed.

    We use sql server 2005 and please help me to remove the jobs error.

    Thursday, September 27, 2012 9:51 AM

Answers

  • You would really need to provide access to AgentDesktop_Wipro_log to the user account running this maintenance job (as I perceive this) if you are interested in using this job. You may need a proxy in case the account running the job has limited rights (looks like the Agent runs under the default limited account in your case).

    Arthur My Blog

    • Marked as answer by Eileen Zhao Thursday, October 4, 2012 7:00 AM
    Thursday, September 27, 2012 2:27 PM