Maintenance Plan & Job Failed

• sumit kumar sahay

  SSC Enthusiast

  Points: 109

  More actions

  April 20, 2006 at 10:33 pm

  #112586

  Hello Friends,

  I encounter the following error in my maintenance plan and job history, please help me finding out the reason and solution.

  1. Job History :

  The job failed.  The Job was invoked by Schedule 9 (Schedule 1).  The last step to run was step 1 (Step 1).

  Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed.

  The job failed.  The owner () of job Optimizations Job for DB Maintenance Plan 'Non-Core Maint Plan' does not have server access.

   

  2: Maintenance plan:

   

  [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 927: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'restore_test' cannot be opened. It is in the middle of a restore.

  [Microsoft][ODBC SQL Server Driver][SQL

   

  3. Log file  :

   

  BACKUP failed to complete the command BACKUP DATABASE [restore_test] TO  DISK = N'E:\SQL_Backups\restore_test\restore_test_db_200604160200.BAK' WITH  INIT ,  NOUNLOAD ,  NOSKIP ,  STATS = 10,  NOFORMAT

   

  Regards,

  Sumit

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  April 21, 2006 at 11:10 pm

  #633639

  Hi ,

  What login SQL agent is running under.

   

  HTH

  from

  Killer