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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 User rights for backup and restore

Author  Topic 

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2007-01-10 : 10:31:05
Guys,

I want to give a user rights to restore and backup database with actually assigning him the system administrator rights.

IS this possible?

Thanks

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-01-10 : 12:31:05
Check out the server and database roles, particularly the db_backupoperator database role.
Go to Top of Page
   

- Advertisement -