July 29, 2009 at 5:16 pm
Hello,
Can anyonea tell me what permissions must i giv to a user inside SQL Server 2005 so that this user can backup and restore a database without given him sysadmin server role
Thanks and regards,
JMSM 😉
July 30, 2009 at 6:02 am
Hi,
Backups:
In order to take backup user must be sysadmin or db_owner or db_backupoperator. I prefer giving db_backupoperator permissions.
Restoration:
If the database being restored does not exist then user must have create database permissions. If the database being restored already exists user must be member of sysadmin or dbcreator roles.
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 23, 2015 at 7:52 am
I know this is an old post but I'm searching for clarification of this. I'm configuring access for a vendor to maintain their own DB. This is in a new SQL instance. They need to do backups / restores occassionally. Can I assign the needed permissions to ONLY their database (which will already be in place) so they can't do anything on anything else? Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply