September 7, 2010 at 5:10 pm
We have SQL SERVER 2000,which we have plan to migrate to SQL SERVER 2008.We also have Transactional Replication set up in SQL SERVER 2000,Which we also want to move it to SQL SERVER 2008.Does truncating transaction log file in SQL SERVER 2008 cause any problem for Transactional Replication.I checked and it seems that the only way to Truncate the transaction log is changing the recovery mode of Database to Simple.Does this cause any problem for Transactional Replication.
I would be grateful if somebody answer my question.
September 7, 2010 at 10:46 pm
I don't think that you have to switch to Simple mode. The part of the T-log that got truncated is the part that is committed regardless of whether the database is the source of replication or not.
September 7, 2010 at 10:59 pm
TRUNCATE_ONLY is gone in 2008. The logs would be truncated only and only when you take the backups. So be ready to have your backup jobs monitored all the time.
September 8, 2010 at 12:15 am
So,by taking a backup from Transaction logs will automatically truncate it.
September 9, 2010 at 7:53 am
Backing up the transaction log does not automatically shrink it, it frees up the space used in the log so it can be reused. If you use FULL recovery mode, it is essential that you perform transaction log backups.
Here is another thread that talks about Log Backups with links to some very good explanations, especially Gail Shaw's article "Managing Transaction Logs".
http://www.sqlservercentral.com/Forums/Topic980494-357-1.aspx
Steve
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply