awba
December 2nd, 2007, 05:28 AM
I've been playing around with replication on SQL Server 2005 over the last couple of weeks and I keep having problems with inadequate file growth on the transaction log file.
As soon as I create the publication -regardless if there are any subscribers or not- the LDF starts growing with any transaction and can only be shrinked after removing the publication object. It looks as if MS had a different understanding of the word "snapshot" than I have. For me it would be perfectly what I need to have the publication object ready to create a snapshot any time I need the actual state of the database to update/overwrite the subscriber(s) - no matter how many or what kind of transactions might have been made in the meantime.
Does anyone know how to set it up this way?
As soon as I create the publication -regardless if there are any subscribers or not- the LDF starts growing with any transaction and can only be shrinked after removing the publication object. It looks as if MS had a different understanding of the word "snapshot" than I have. For me it would be perfectly what I need to have the publication object ready to create a snapshot any time I need the actual state of the database to update/overwrite the subscriber(s) - no matter how many or what kind of transactions might have been made in the meantime.
Does anyone know how to set it up this way?