MS SQL db ccount question


What account in SQL will give me rights to execute Replication and copy DB?

I can't use sysadmin account

What rules accounts will allow execute this kind of task?

Please advice, M
Who is Participating?
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
You'll always need sysadmin role to enable a SQL Server instance to be a Distributor, Publisher, or Subscriber. As you'll need the same role to enable a database for replication.
If you can get a DBA to enable those for you then you'll need to be db_owner of the database to create the desired replication.
michalek19Author Commented:
can you create tasks, schedule tasks as db_owner
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.