Post reply

maintenance plan failure (SQL 7 / NT4)

  • August 18, 2005 at 2:21 am

    #167948

    I'm experiencing a strange behavior since a couple of weeks with the maintenance plans on my server : the .BAK files are no more generated although there is enough place on the disk.

    Last week I decided to restart the SQL Server Agent. In the following night, the .BAK files have been generated. I thought everything would be all right so I didn't care any longer.

    Yesterday I decided to have a look at these maintenance plans and noticed that no .BAK file has been generated since then. I looked at the history of the maintenance plans : nothing written since the success of the last week backup. I looked at the history of the job : even the last week backup has not been recorded... I looked at the task manager : many sqlmaint.exe processes were running. We killed all this processes and restarted SQL Server Agent.

    Last night the .BAK file have been generated, new entries were added to the history of the maintenance plans but once more not any line in the history of the jobs and still 2 alive sqlmaint.exe processes.

    My computer runs under Windows NT4 with SQL Server 7.00.961 (it means SP3).

    Has someone already seen that king of behavior ?

    Thank's for your help

    Olivier Côte

    CI-Soft

  • August 18, 2005 at 8:04 am

    #583036

    It's going back a while but I seem to remember seeing this sort of thing if one of the windows event logs was full, can you check and make sure you're not at the limit, or that they're allowed to overwrite if needed.

    Mike

  • August 18, 2005 at 8:29 am

    #583065

    Currently the log event wasn't configured in that way but 'keep 7 last days'. I've changed this option. Also the Application EventLog was nearly full. Maybe you're right.

    This morning we have rebooted the system and unchecked the option 'send a report' on the maintenance plans because we had the impression that was were it was blocked.

    After the reboot, we received report email from the beginning of August.

    We'll see tomorrow if the backup has run right and if the histories are updated and if the sqlmaint.exe processes are sitll there. If so and if it still works for a few days, we'll try to check the report option and see if anything's still all right.

    Thank you for the suggestion !

    Olivier

  • August 19, 2005 at 1:11 am

    #583413

    Last night everything seems to have been right done : the histories were updated, no pending sqlmaint.exe.

    Let's see for a couple of days.

    Olivier

  • August 19, 2005 at 1:50 am

    #583419

    Lets hope it's fix it

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply