cancel
Showing results for 
Search instead for 
Did you mean: 

Backing up SQL servers

Kevin_Everts
Level 3
Okay, this may be a dumb question, but I'm hoping someone will be nice and answer it. I am trying to backup a bunch of databases (2 on SQL server and a few MSDE databases on servers) but I'm having trouble. What permission do I need to give the backup account to be able to backup these databases? Backup Operators doesn't seem to be enough. I can get it to work if I make the account a domain administrator, but I obviously don't want to do that.
3 REPLIES 3

Dhavalrai_Trive
Level 5
You can use the SQL Sa account to backup just the SQl databases or try creating a new account with the following rights on SQL

1> Under server roles grant system administrator and

2>Under database access grant DB owner permissions for each database.

Abhinav_Bindroo
Level 6
In addition to this following technote might be useful

http://support.veritas.com/docs/234733

Cheers

Abhinav_Bindroo
Level 6
Assuming the solution provided is correct. Also, there is no response from the customer within 2 days from the last reply by Veritas