?
Solved

SQLMAINT failed

Posted on 2006-05-11
3
Medium Priority
?
283 Views
Last Modified: 2006-11-18
I have 2 maint plans (db and trn), but they don't delete db.bak and trn as expected.

Deleting old text reports...    0 file(s) deleted.

End of maintenance plan 'swdatasqltrn' on 5/10/2006 2:02:41 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

Deleting old text reports...    1 file(s) deleted.

End of maintenance plan 'swdatasqldb' on 5/11/2006 1:02:14 AM
SQLMAINT.EXE Process Exit Code: 0 (Success)

How do you troubleshoot them?
0
Comment
Question by:JohnLucania
  • 2
3 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 2000 total points
ID: 16663968
What account is running the sqlagent service?
Does that account have the required permissions on the folder you want to delete from?

Look at the servers application logs - any clues?
Go into the properties of the maintenance plan, look under reporting, is there a file path to a report?
If so, look for clues there.
0
 

Author Comment

by:JohnLucania
ID: 16679603
>> What account is running the sqlagent service?
>> Does that account have the required permissions on the folder you want to delete from?

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'DATASQL' as 'NT AUTHORITY\SYSTEM' (trusted) Starting maintenance plan 'swdatasqldb' on 5/11/2006 1:00:01 AM

Do you see any issues with this account?
0
 
LVL 29

Expert Comment

by:QPR
ID: 16679644
Does the "system" account have the necessary permissions to delete from that folder?
Is there any logging enabled for the plan
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question