sql server replication: Impacts of replication with simple recovery model -- sql server replication

Impacts of replication with simple recovery model

Sanjay
4/21/2005 3:30:02 AM

sql server replication:

hi,
i have a database which is around 50 GB in size and is replicated into other
server/db.
we are installing new version where we have changed nvarchar datatype to
Ntext datatype (Alter table) of one of the table which is having 54,09,873
rows.
Because of this change log and data file size are getting increased and
installation is taking 3-4 hours.

My questions are
1) Can i change recovery model to simple before this script run and the
moment it finishes i will set to FULL.
2) will it impact replication, till the time script is running we are
stopping replication and then enable it once it is finished.
But if i change recovery model to simple nothing will be logged in Logfile
and once this script finishes how data and schema changes will be replicated
to another database.

can anyone help me on this.

--

Re: Impacts of replication with simple recovery model

Hilary Cotter
4/21/2005 7:42:13 PM

1 & 2) yes, change it to any mode without impacting replication in the
least. Keep in mind that you can't run an alter table on tables you are
replicating.

[quoted text, click to view]