October 16, 2012 at 9:02 am
A user requires out of hours backup and restore of a SQL 2008 R2 database on a regular basis. I could schedule a script to run but don't know what time this would be required. I also do not want to give the user access to the server therefore is there anything else that anyone can suggest that I could do or have implemented in their environment?
I am looking into db_backupoperator permissions for the user on the said database but assume the user would require permissions to the backup folder on the server too?
Any suggestions would be appreciated.
Thank you.
October 16, 2012 at 12:10 pm
Hi,
In our environment all backups and restore are handled by DBAs.
so, you should not be handling any permissions to the any for backup.
If this is a scheduled backup then you can have a maintenance plan and
have it scheduled per user requirement.
Let me know if you need any more info....
Thanks
Satyen
MSSQL
October 16, 2012 at 12:58 pm
kkanaya (10/16/2012)
A user requires out of hours backup and restore of a SQL 2008 R2 database on a regular basis. I could schedule a script to run but don't know what time this would be required. I also do not want to give the user access to the server therefore is there anything else that anyone can suggest that I could do or have implemented in their environment?I am looking into db_backupoperator permissions for the user on the said database but assume the user would require permissions to the backup folder on the server too?
Any suggestions would be appreciated.
Thank you.
use an SSIS package and run it under the SQL Server agent
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply