Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-07-03 : 12:14:38
|
| Hi,I am db_owner on xyz database. On the server side I have only Public access. When I am trying to backup this database, there is error:The execute permission was denied on the object 'xp_fleeexist", database 'mysqlsystemresource', schema 'sys. (Micorosft SQL Server Error 229). Please help.Thanks |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-07-04 : 15:09:44
|
| Any help? |
 |
|
|
pagan1234
Starting Member
7 Posts |
Posted - 2012-07-05 : 10:25:16
|
| Hi Peter,BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.Source= http://msdn.microsoft.com/en-us/library/ms186865(v=sql.105).aspx |
|
|
|
|
|
|
Cannot take backup