Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    New York
    Posts
    35

    Unanswered: Maintenance Plan,SQL Server 2000

    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.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Any chance you can post the command(s) you are using to backup your user and system dbs?
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    May 2002
    Location
    New York
    Posts
    35
    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

Posting Permissions

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