+ Reply to Thread
Results 1 to 2 of 2

Should replicated reporting db be read only?

  1. 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?



  2. 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?
    >



+ Reply to Thread