ADSM-L

Re: TDP for SQL: does the id absolutely require SA priv?

2005-08-26 02:23:18
Subject: Re: TDP for SQL: does the id absolutely require SA priv?
From: "Leonard, Christopher A" <christopher-leonard AT UIOWA DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 26 Aug 2005 01:23:06 -0500
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
___________________________________________

<Prev in Thread] Current Thread [Next in Thread>