Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mirroring Expand / Collapse
Author
Message
Posted Friday, January 17, 2014 2:31 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, October 23, 2014 5:15 PM
Points: 610, Visits: 788
Hi,
I have a doubt. What we can do if the log file has large grow in the principle server.
Post #1532291
Posted Friday, January 17, 2014 3:40 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:09 PM
Points: 20,739, Visits: 32,528
ramana3327 (1/17/2014)
Hi,
I have a doubt. What we can do if the log file has large grow in the principle server.


Not sure what you are asking here.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1532318
Posted Friday, January 17, 2014 4:01 PM This worked for the OP Answer marked as solution
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:38 AM
Points: 5,879, Visits: 13,010
you can still shrink it if thats what you mean.

If the log is growing because communication with the mirror is lost, then if you cannot reestablish mirroring you will have to break the mirror so the log can be truncated.


---------------------------------------------------------------------

Post #1532323
Posted Sunday, January 19, 2014 11:07 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 4,406, Visits: 6,270
You posted this in mirroring forum, so if mirroring is actually set up you can use the monitor gui for that to see how backed up things are.

Also, a VERY VERY common problem is people having databases in FULL recovery mode but not doing any form of TLOG backup. A FULL backup will NOT flush committed transactions from the tlog!!!


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1532460
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse