July 22, 2013 at 4:37 am
what is the difference between the database logfile and the database configured under replication ?
July 22, 2013 at 4:46 am
Don't understand what you're asking.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2013 at 5:47 am
just to check is any particular difference in between them ?
July 22, 2013 at 5:55 am
I hope you mean - if there is any difference in the transaction log file, for the DB on which replication has NOT been configured, and for the one on which replication has been configured.
If so,
Architecture wise - there is no difference!
Usage wise - There are differences! If a DB is in SIMPLE then truncation of inactive portion would happen whenever checkpoint occurs.
If a DB is in FULL then log backup would truncate inactive portion of log file.
Whereas if Transaction replication is configured on a DB, then the log truncation would be based on the mark on log records whether they have been replicated or not.
I hope same case for peer-to-peer replication as well. And NO other type of replication is using Log file.
Please read to know more about T-log file architecture and behaviour @
http://www.sqlservercentral.com/stairway/73776/
Experts, please validate and correct me if I am wrong!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply