-
Should replicated reporting db be read only?
We are using transactional one way replication to keep a 2nd copy of our
database that we are using for reporting purposes. Should this database be
set to read-only? Besides controling write permissions, are there any
advantages/disadvantages to having a database set to read only? Does it
improve performance?
-
Re: Should replicated reporting db be read only?
No, don't do that. Replication will be unable to write to your database.
Put all database users (except the replication account) in the db_denywrite
role.
That should be all you have to do.
"Dan" wrote in message
news:um3PxnX1IHA.524@TK2MSFTNGP05.phx.gbl...
> We are using transactional one way replication to keep a 2nd copy of our
> database that we are using for reporting purposes. Should this database be
> set to read-only? Besides controling write permissions, are there any
> advantages/disadvantages to having a database set to read only? Does it
> improve performance?
>