Post reply

Maintenance Backup & Restricted User Mode

  • May 10, 2012 at 8:26 am

    #98633

    By having a database in Restricted User Mode, will that prevent the backup job in the maintenance plan from running. I'm trying to figure out why the backup(maintenance plan) didn't run.

  • May 11, 2012 at 2:16 am

    #1486151

    what level of rights does the account have which is backing up the database?

    restricted user only allows members of sysadmin/dbcreator/db_owner roles to connect to the database, so if the account only has db_backupoperator then that would be the cause of the error, if it has SA access then no.

    if you could post the error message you get from the backup task we could take a deeper look

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply