var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Needs to be in sysadmin server group according to bol.
Another reason for not using the exe?
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,
I meant it is 'another reason for not using maintenance plans'.
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.
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.
Is there a common solution for "versioning" backup files when using "BACKUP DATABASE"? i.e to save the file as <name>.<date>.bak