SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Transaction Log Full


Transaction Log Full

Author
Message
fatinfzi
fatinfzi
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: General Forum Members
Points: 96 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.
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64283 Visits: 18570
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

fatinfzi
fatinfzi
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: General Forum Members
Points: 96 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.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)

Group: General Forum Members
Points: 214536 Visits: 46268
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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


Jayanth_Kurup
Jayanth_Kurup
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5429 Visits: 1351
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
SQLisAwE5OmE
SQLisAwE5OmE
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2908 Visits: 3075
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search