Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721

    Unanswered: DB Maintenance Job not running

    Hi. I'm totally new to this whole sql server world so bear with me on this. I tried creating a maintenance plan which consist of a backup of all of my db on the server and whenever I try to run the job it creates, it just hang there like I have done nothing. I have created the maintenance plan with the administrator account on the server and I have tried to run it like that but no dice. If any of you can give me any hint on what could be happening, I would be very appreciated.

    Thanks!
    Last edited by JMartinez; 11-03-05 at 09:05.

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Which administrator? Windows, sa, or the service account? Does "the administrator" have rights to write the files to the backup location?

    Have you checked to see if the backup files are being created in the location you specified in the maintenance plan. You did specify full backup and a location didn't you? Did you also check the box to include a log of the operation in the maintenance plan? Have you checked there?

    If this is a transaction log backup, remember that if you included databases in simple recovery mode, your job will error out.

    You do know that backups are not instantaneous, they do take time to occur.

    Start with basic troubleshooting. Read Books Online. Google the subject.

    Oh, by the way ... read the sticky at the top of the forum and include pertinent information. SQL Server? What version and service pack?

    Help us to help you. You've left out a lot of information, and a lot of checking that you need to do.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Hi Tomh53. I figured out what the problem was. I removed the account 'BUILTIN\Administrator' from my sql logins and that caused SQL Agent not to run the jobs getting the error message Login failed for user 'NT AUTHORITY\SYSTEM'. I finally fixed the problem adding this login to sql and giving it sysadmin privileges. Thank you very much for your assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •