Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-18 : 09:21:36
|
| Pang writes "Please help me regarding Transactional Replication in SQL Server. I am very confused regarding the "transaction log marked for replication" which Log Reader reads in Transactional Replication. May i know whether the Transaction Log that Log Reader reads has the extensions of .ldf ? What is the difference between .ldf and .trn ? What is the difference between the Transaction Log that Log Reader Agent reads and Transactional Log when backup is used ? I am longing for your help with great enthusiasm. Thank you very much." |
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2003-04-22 : 15:01:38
|
| There is only one transaction log, so the log reader agent uses the same one as backup/restore. It can be split across mutliple files, but it's one log. I think .ldf is just a naming convention. |
 |
|
|
|
|
|
Log Reader in Transactional Replication