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

    Unanswered: Maintance plan Problems

    Hello, I've been having some problems with my Maintainance plan in SQL Server 2000. It will occationally quit working for days at a time. Sometimes it will do everything but back up the databases, and it steadfastly refuses to delete log backups over 6 weeks old (as I have asked it to). Anybody have any advice for me? Please, someone tell me the only thing to do is to take it out in the parking lot and kick it around. Thanks

  2. #2
    Join Date
    Mar 2003
    Posts
    2

    By the way

    There isn't anything else on the server (Win 2000), and its configured to stay powered up all the time. Theres also no significant traffic when its configured to run.
    Thanks

  3. #3
    Join Date
    Apr 2004
    Location
    Pasadena. MD
    Posts
    2

    Question Security

    I would like to know if there is any other way of allowing a user to be able to run maintenance plan or create databases without being sysAdmin.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    GRANT DUMP DATABASE , DUMP TRANSACTION TO <user_name>
    go
    exec sp_addsrvrolemember <user_name>, dbcreator
    go

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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