Replication-- need advice

• Monica Taran

  Newbie

  Points: 1

  More actions

  July 25, 2006 at 8:40 am

  #91237

  Hi all,

  We are trying to set up transactional replication.  Between Various teams:  Namely Network and DBA, there is a distinct role definition and split of responsibilities in our organization.  The DBA's are 'SA' on the SQL Server databases and the Network people are the 'SA' on the Servers that host the SQL Server or the o/s.  The question is Does the DBA need to be the Local Admin on the physical server to be able to set up replication? 

  Thank You all in advance.

   

  M.

• Jules Bonnot

  SSCertifiable

  Points: 5488

  More actions

  July 26, 2006 at 3:58 am

  #651562

  Nope shouldnt need to.

  Replication should really be DBA responsibilty as its her who wil get it in the neck if the data is missing currupt etc.

  www.sql-library.com[/url]

• Richard Josey

  Ten Centuries

  Points: 1076

  More actions

  July 26, 2006 at 10:36 am

  #651705

  It is also the DBA which will deal with all the problems which can occur with Transactional Replication.

  The DBA should therefore have enough access and responsibilty to both sides for troubleshooting.