January 3, 2006 at 12:41 pm
Hello,
I noticed that not all database / log backup events are logged into Windows Application Log on one Windows 2000 server with SQL Server 2000. We are talking only about the event 17055 - log and database backups. These events do take place on schedule and all events are logged corrrectly into SQL Server Log. But Application Log shows less then half of these events randomly. So far I noticed it on only one server.
For example, I have a maintenance plan to back up 6 databases daily. I also have another plan to backup a transaction log of one of the databases every 4 hours, so I should have 6 log backups daily. I do have all backup files in the the backup directory with the correct time stamps, both jobs are running correctly, SQL Server log contains 6 records for log backups and 6 records for database backups daily at the correct times. But Windows Application log contains half of these records. For one day it could be 2 or 3 database backup events logged and 3 or 4 log backup events logged. For yesterday I have none logged in the Application Log for the event 17055 while there are a lot of records for other events from other sources.
Did someone see this behavior before?
Regards,Yelena Varsha
January 4, 2006 at 10:18 am
It may be that the application event log has become corrupt. You've got a couple of choices. First have your Windows Admin clear the application event log. If this does not solve the issue then have your Windows Admin delete C:\WINDOWS\system32\config\AppEvent.Evt (this is the default location). The next application event will automatically recreate it for you.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
January 4, 2006 at 11:21 am
Rudy,
Thanks. I will do that and will let you know if it helped.
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply