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

Database Mirroring Expand / Collapse
Author
Message
Posted Tuesday, December 3, 2013 11:31 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 7:14 AM
Points: 657, Visits: 882
HI All,

In Production server, Principal database having 120GB log file(mirroring configured)

Why ldf file is taking that much space, How I can truncate log file.?
What is best way to shrink log file?
Post #1519483
Posted Tuesday, December 3, 2013 11:49 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 42,443, Visits: 35,498
Do you have regular log backups running? If not, that's why the log is so large.

Please read through these:
http://www.sqlservercentral.com/articles/Administration/64582/
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1519494
Posted Tuesday, December 3, 2013 11:55 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 7:14 AM
Points: 657, Visits: 882
GilaMonster (12/3/2013)
Do you have regular log backups running? If not, that's why the log is so large.



Thanks for u r quick reply , We are not taking log backups but we are taking week full backup.
If i take log backup from principal server, is there any impact on mirroring ?
Post #1519496
Posted Tuesday, December 3, 2013 11:58 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 42,443, Visits: 35,498
PRR.DB (12/3/2013)
We are not taking log backups but we are taking week full backup.


There's your problem. If a database is in full recovery, and for mirroring it has to be in full recovery, you MUST take regular log backups or the log will grow until it fills the disk. Please read the two articles I referenced.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1519497
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse