Posted by monkeybrains on 10/07/05 22:12

I understand you can manually backup the database from EM. But can you
manually kick off the scheduled job without a problem? Go to EM /
management / SQL Server Agent / Jobs .... and look for the scheduled
package. Right click, Run, and see what happens. If it fails after a
manual run, try recreating the backup scheduled job. If it runs
successfully, the SQL Server Agent login doesn't have the right
permission.

• Next in forum: Temp Table on Linked Server
• Prev in forum: Re: PK and Timestamp in same table?
• Thread view: Re: Backup for one new DB failing in regular maintenance job Error 3201

[Reply to this message]