Friday, February 24, 2012

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!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.|||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.

No comments:

Post a Comment