Transaction log is full - how to fix this?

You need to shrink the log.  I have had it do this to me in LIVE when backups weren’t working.  We have used these instructions, but we also have increased the size of the log. 

TransactionLogFullError

Error: Tessitura won't load - transaction log is full.

1. Change recovery model from 'Full' to 'Simple'

2. shrink impresario database

3. change recover model from 'Simple' to 'Full'

use this script to do this:

USE [master]

GO

ALTER DATABASE [impresario] SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE [impresario] SET RECOVERY SIMPLE

GO

USE [impresario]

GO

DBCC SHRINKDATABASE(N'impresario' )

GO

USE [master]

GO

ALTER DATABASE [impresario] SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE [impresario] SET RECOVERY FULL

GO

Trudy Guest,

ArtTix Systems Administrator

801.323.6969

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Natasha Purkiss
Sent: Wednesday, August 29, 2012 9:33 AM
To: Trudy Guest
Subject: [Tessitura Technical Forum] Transaction log is full - how to fix this?

Hi everyone,

It’s been a while since I used out Test system and upon trying to log in today I got the error “The transaction log for database ‘impresario’ is full”.

I can see allot of conversation in the forums about transaction logs but seems I know very little about this topic I don’t really know where to start. Can someone point me in the right direction or have any documentation on how to solve this? I don’t know what kind of backup our Test  database even has, or where to find this.

I downloaded the free trial of RedGate SQL Script Manager that I saw recommended by a few but not sure where to go from there.

Thanks for any help!

Natasha

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

You need to shrink the log.  I have had it do this to me in LIVE when backups weren’t working.  We have used these instructions, but we also have increased the size of the log. 

TransactionLogFullError

Error: Tessitura won't load - transaction log is full.

1. Change recovery model from 'Full' to 'Simple'

2. shrink impresario database

3. change recover model from 'Simple' to 'Full'

use this script to do this:

USE [master]

GO

ALTER DATABASE [impresario] SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE [impresario] SET RECOVERY SIMPLE

GO

USE [impresario]

GO

DBCC SHRINKDATABASE(N'impresario' )

GO

USE [master]

GO

ALTER DATABASE [impresario] SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE [impresario] SET RECOVERY FULL

GO

Trudy Guest,

ArtTix Systems Administrator

801.323.6969

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Natasha Purkiss
Sent: Wednesday, August 29, 2012 9:33 AM
To: Trudy Guest
Subject: [Tessitura Technical Forum] Transaction log is full - how to fix this?

Hi everyone,

It’s been a while since I used out Test system and upon trying to log in today I got the error “The transaction log for database ‘impresario’ is full”.

I can see allot of conversation in the forums about transaction logs but seems I know very little about this topic I don’t really know where to start. Can someone point me in the right direction or have any documentation on how to solve this? I don’t know what kind of backup our Test  database even has, or where to find this.

I downloaded the free trial of RedGate SQL Script Manager that I saw recommended by a few but not sure where to go from there.

Thanks for any help!

Natasha

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!