Transaction logs in Mirroring [Resolved]

Posted by Yrajudba under Sql Server on 9/29/2011 | Points: 10 | Views : 1035 | Status : [Member] | Replies : 2
Hi,

Please let me know, in Mirroring concept Transaction logs will get created ? If so where to check? I checked but i dint find anywhere.
i implemented mirroring concept, mssql server 2008R2 on windows7

waiting for your answer

Thanks
Raju




Responses

Posted by: Yrajudba on: 9/30/2011 [Member] Starter | Points: 25

Up
0
Down

Resolved
HI Pandian,

Thanks a lot for clearing my doubt.

thanks
Raju

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: PandianS on: 9/29/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
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

Login to post response