Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: Maintenance Plan bug on SQL Server 2005

    Hello, everyone:

    I have a strange trouble on SQL Server 2005 on XP/local and Win 2003/server. When I connect local database and create a backup plan named by "backup plan", I can see the name under "maintenance plan" and "Jobs" under SQL Server Agent. But if I connect to server database and do the samething, I cannot see the name under "maintenance plan". I can see the name under "Jobs" under SQL Server Agent. But cannot delete this job, and message:

    Drop failed for job "Backup Plan".(Microsoft.SqlServer.Smo).

    Did someone meet this bug and have suggestions?

    Thanks

    ZYT

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Permissions? Do you have the same permissions to the server as you do to your local SQL Server?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Mar 2003
    Posts
    223
    Hi, Pootle:

    Thanks for reply.

    I have sysadmin permissions to the server.

    ZYT

    Quote Originally Posted by pootle flump
    Permissions? Do you have the same permissions to the server as you do to your local SQL Server?

  4. #4
    Join Date
    Mar 2003
    Posts
    223
    Hi, Pootle:

    The server is the remote one that our company just got from someone else. I login by "Remote Desktop Connection" and check SQL Server. From Start - Programs - SQL Server 2005, there is only "Configuration Tools" available, no other componences like "SQL Server Management Stadio". This is first time I sam and confused. What was happened?

    When I connect server from SQL Server, I can all tables and stored procedrues.

    Thanks

    ZYT


    Quote Originally Posted by pootle flump
    Permissions? Do you have the same permissions to the server as you do to your local SQL Server?

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    As I remember, there was a bug in SQL 2005 SP2 that affected Maintenance plans. Check to see what hotfixes are available.

Posting Permissions

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