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

Transaction Log Full Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 9:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 2013 9:54 PM
Points: 24, Visits: 88
Hi,
I need help with my database. The database is mirror to another database and not the disk is full. No free space for transaction log. One of my colleague suggest me to remove the mirroring and change the recovery mode to simple. But i need the database to be mirrored to another database. Please help me on this.
Post #1435248
Posted Monday, March 25, 2013 10:21 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 20,462, Visits: 14,089
Is the transaction log full or is it that the log grew and filled the disk?

Is the issue on the principal or on the mirror?

Do you have additional disk space on a different volume available (principal or mirror)?

what is the value of log_reuse_wait_desc in sys.databases?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1435252
Posted Monday, March 25, 2013 10:39 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 2013 9:54 PM
Points: 24, Visits: 88
SQLRNNR (3/25/2013)
Is the transaction log full or is it that the log grew and filled the disk?

Is the issue on the principal or on the mirror?

Do you have additional disk space on a different volume available (principal or mirror)?

what is the value of log_reuse_wait_desc in sys.databases?



the log grew and filled the disk. It happens on the principal db. i dont have any additional space.
Can u help me to check the log_reuse_desc value?
sorry im very new in this.
Post #1435253
Posted Tuesday, March 26, 2013 2:13 AM


SSC-Forever

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

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 41,529, Visits: 34,445
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/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 #1435306
Posted Tuesday, March 26, 2013 2:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 03, 2013 11:33 PM
Points: 1,789, Visits: 1,013
select log_reuse_wait_desc, name
from sys.databases

If you have the option you can add an additional log file , before that please make sure you go thru the link Gail provided. it will help fix the root cause of the issue.


Jayanth Kurup
Post #1435310
Posted Wednesday, March 27, 2013 7:32 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, February 24, 2014 1:04 PM
Points: 383, Visits: 2,351
fatinfzi (3/25/2013)
Hi,
I need help with my database. The database is mirror to another database and not the disk is full. No free space for transaction log. One of my colleague suggest me to remove the mirroring and change the recovery mode to simple. But i need the database to be mirrored to another database. Please help me on this.


Hi, I went through similar situation recently, my log drive was getting full and when I checked the log backups, it was failing due to space also......so, to fix this issue, I took a manual log backup and shrank the log file to free up space. Sometimes you have to do more than 1 log backups in order to shrink.

So, I am not sure if you have same scenario, but it seems like log backup issue.

Also, check the mirroring monitor and see how much unsent log, etc.

Regards,
SueTons.


Regards,
SQLisAwe5oMe.
Post #1436239
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse