August 7, 2010 at 5:53 pm
Hi,
I have a transaction log backup maintenance plan which is failing for one of my database. The job was running fine and since yesterday the job is failing. The SQL Server agent job executes on a scheduled process every one hour. During this scheduled run it is failing. The job owner has all permissions and it is not happening for other maintenace plans for other databases.The job owner has also the complete access to the destination folder. But when I execute the job manually it is succeeding.
The point here is the job is not executing on a scheduled run but when when executed manually it succeeds.
We have the same type of maintenace jobs running for other databases also, but we are not facing this issue. Only for this particular job the the maintenance job is failing.
Can anyone please help me in solving the issue.
Please find the logs attached
Job 'Maintenance RTA Tlog Backup' : Step 1, 'Step 1' : Began Executing 2010-08-07 23:33:00
output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(null)
Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.4035.00
Copyright (c) Microsoft Corporation.
(null)
Logged on to SQL Server 'XXX\YYY'
as 'admin\MSSQL' (trusted)
(null)
Starting maintenance of database 'RTA' on 07/08/2010 23:33:00
(null)
[1] Database RTA: Transaction Log Backup...
(null)
End of maintenance for database 'RTA' on 07/08/2010 23:33:00
(null)
SQLMAINT.EXE Process Exit Code: 1 (Failed)
(null)
Msg 22029, Sev 16, State 1: sqlmaint.exe failed. [SQLSTATE 42000]
August 8, 2010 at 12:19 pm
Adding an output file for the job step will give more information on the failure.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 8, 2010 at 4:22 pm
Hi,
The above log is from the job output file.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply