Hi,
I set up a scheduled Maintenance Plan for DB backups. For some reason just user DBs backups are performed. For master and msdb I can run backups manually via T-SQL or Enterprise Mngr and do not have any problems. But it doesn't work with Maint. Plan. There are no any error messages in SQL error log, the only error message I can see comes from View Job History(SQL Server Agent, Jobs) and says 'job failed'.
I administrate several servers and never had this kind of problem.
I logged as 'sa' .
Any ideas?
I appreciate all your help.:confused:Any chance you can post the command(s) you are using to backup your user and system dbs?|||Thank you for your response. I've fixed the problem - it was a security issue for the NT account on master & msdb files.
Thanx again
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment