March 17, 2005 at 8:19 am
Hai,
I have configured maintenance plan for the database transaction log bkp (occurs every 1 hour), it was working properly and it got stopped afte two three days. SQL Agent is running perfectly and other maintenance plans are also working perfectly.
Can anybody tell what could be the reason?
pls help
subban
March 17, 2005 at 8:42 am
I've seen maintenance plans to backup the transaction log stop working in the past because of a lack of available disk space where the backup is going to, I'm sure that you will have checked but just thought that I should point it out in case you haven't.
It could also be that your application log is full, this happened to us once a long time ago on an inherrited system and the most worrying things was that SQL didn't report it as a failure so if I hadn't been doing manual checks each week we wouldn't have know about it until we needed it and it wasn't there.
March 17, 2005 at 9:11 am
application log is not full,
but in application log it is showing log failed (no permission to write ), but it was running two days back
SQL Agent service is running under (system account)
subban
March 17, 2005 at 9:33 am
I know it's a stupid question but is the scheduled job set to run as SA or an administrator?
March 17, 2005 at 9:51 am
Has anyone changed the recovery mode of your database to simple?
March 18, 2005 at 2:00 am
recovery mod is still FULL,
is there any problem if SQL Agent is running under system account ?
In application log i am getting write permission error for this job (but how come it can ran two days back ??)
subban
March 18, 2005 at 9:05 am
Look,
I did have a case when a system support took LOCALSYSTEM account from the ACL on SQL Server and WINNT folders. It happened overnight. SQL Server could not start at all. Actually I had a couple of similar cases.
Please, do verify that SYSTEM is listed in ACL (Access Control List) for the folder with write permissions even if you are sure that was the case two days ago. On Windows XP and Windows 2003 server got to folder properties, Security Tab, Advanced button and go to Effective Permissions tab to see the effective permissions on this folder for particualr account.
Another reason for wrute access denied if the file that it is trying to write to is opened by other process.
Yelena
Regards,Yelena Varsha
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply