Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2002
    Posts
    5

    Unanswered: xp_sqlmaint permissions

    When I try to run xp_sqlmaint, I get the message: -

    Login '<backupuser>' is not the DBO of database '<dbname>' so cannot run SQLMAINT.EXE.

    I'm using a non-trusted login for a user that belongs to the 'db_backupoperator' group and has been granted execute on xp_sqlmaint.

    Surely I don't have to give a Backup user DBO permissions on a DB?

    Niall

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Needs to be in sysadmin server group according to bol.
    Another reason for not using the exe?

  3. #3
    Join Date
    Jan 2002
    Posts
    5

    xp_sqlmaint permissions

    Sorry, I get the same when running the exe (I think the xp just calls the exe/dll anyway).

    It does not seem to make sense that the user must be an Administrator or a DBO.

    Thanks for the reply,
    Niall.

  4. #4
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    I meant it is 'another reason for not using maintenance plans'.

  5. #5
    Join Date
    Jan 2002
    Posts
    5
    If I deploy MSDE then there is no front end (Enterprise Manager) for the SQL Agent so it was easier to run sqlmaint. I could write my own VB front end with DMO but I wanted to avoid that.

    Niall

  6. #6
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Don't use enterprise manager much either.
    I always do this sort of thing i a stored procedure.
    Everything that maintenance plans do is really easy to code yourself and gives you more control and you are more sure of what it is doing.

  7. #7
    Join Date
    Jan 2002
    Posts
    5
    Related question:-

    Is there a common solution for "versioning" backup files when using "BACKUP DATABASE"? i.e to save the file as <name>.<date>.bak

    Niall

Posting Permissions

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