Replication and ReadOnly Database

Hi All,
Once i set the database to readonly mode, may i know if i can continue to
use trsnaction replication to replciation data from the readwrite db to the
readonly db?
Thx a lot
Regards.
NortnoNorton wrote:
> Hi All,
> Once i set the database to readonly mode, may i know if i can continue to
> use trsnaction replication to replciation data from the readwrite db to th
e
> readonly db?
> Thx a lot
> Regards.
> Nortno
>
Are you asking if you can make the subscriber database read-only?
Replication works by writing transactions to the subscriber database
that have been received from the publication database. If the database
is read-only, how's it going to write those transactions?
Sounds like you're trying to prevent users from changing data in the
subscriber database. If so, just deny them write access to the database
(db_denydatawriter).|||Thx a lot
^_^
"Tracy McKibben" <tracy@.realsqlguy.com>
'?:OVgWGGknGHA.3340@.TK2MSFTNGP02.phx.gbl...
> Norton wrote:
> Are you asking if you can make the subscriber database read-only?
> Replication works by writing transactions to the subscriber database that
> have been received from the publication database. If the database is
> read-only, how's it going to write those transactions?
> Sounds like you're trying to prevent users from changing data in the
> subscriber database. If so, just deny them write access to the database
> (db_denydatawriter).