Re: TDP for SQL: does the id absolutely require SA priv?
2005-08-26 02:23:18
I would guess that the TDP account for SQL Server just has to be a
member of the db_backupoperator role in each database. Once you give it
this role in each database (including model) it will automatically have
this role in any new database (because new databases start off as copies
of model).
Hope this helps.
-Chris
___________________________________________
Chris Leonard, The Database Guy
http://www.databaseguy.com
___________________________________________
|
|
|