Post reply

Last backup was three weeks ago!!??

  • June 8, 2006 at 9:36 pm

    #153031

    I was trolling the SQL Server hard disks and noticed that the last backup file is dated 33rd May. This is the same for ALL the other databases too.

    I checked the DB Maintenance Plans and the DBMP history shows that the last time the DBMP ran was 24th May (it backs up the transaction logs every 4 hours). All schedules in the DBMP are enabled and do not have an End date.

    What do I do to get it working again?

    SQL Server 2000 V8.00.2039 SP4.

  • June 9, 2006 at 8:22 am

    #642816

    Are there any error messages? In Enterprise Manager, you should be able to click on Jobs and find the maintenance job. Right click on it, select View Job History, then check the box for Show All Steps. See if there are any errors.

    Also, check your Windows Event Viewer Logs.

    Is your backup to disk or tape? Is the backup location full or unaccesable?

    -SQLBill

  • June 9, 2006 at 8:25 am

    #642818

    Another thing....you say the schedule is enabled, but is the JOB enabled? It's two different things. Right click on the job, in the pop-up list there should be either DISABLE or ENABLE. If the job is enabled, DISABLE should be shown. If ENABLE shows, click on it.

    -SQLBill

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

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