SQL Server Snapshot Replication Subscriber (Editable or Read-Only)

Posted by NateReid on Server Fault See other posts from Server Fault or by NateReid
Published on 2010-12-14T13:10:02Z Indexed on 2012/04/09 5:32 UTC
Read the original article Hit count: 500

Filed under:
|
|

I need to create a copy of my SQL 2008 R2 Enterprise database and have it located on the same server as the original. I will be using this second copy of the database as the target of a mostly read-only website. I understand that if I create this copy of the database using snapshot replication that all data changes in the subscriber database will be overwriten in the event of the next replication. The web application will try to write to this database to record login attempts, etc and will fail if its source database is read-only. In my case I do not need to keep these auditing records and they can therefore be overwriten each time a new snapshot is applied.

My question is whether SQL Server forces the subcriber database to be read-only and is there any way around this?

Thank you,

Nate

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about sql