Hi Raju
Normally, Every transaction will be logged into the Log file.
But, In Mirroring, Transaction Log will not be created SEPERATELY. Every transaction will be propagated to the Mirror server and Primary server. Once the Mirror database is committed then only the Primary Server transaction get committed. So, Transaction Log will not be created for MIRRORING anywhere seperately.
But, In Log Shipping, Transaction Log BACKUP will be performed as per the configuration with time duration...
If you want to know the actual Log & Data file of the Database
Use <DatabaseName>
EXEC Sp_helpfile
Go
If you want to read every Transaction Log entry:
Select * from fn_dblog(null,null)
Go
Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions
Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator