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
We have a couple of jobs set up that does a backup of test, one that shrinks the database, and one that deletes the oldest backup. We keep backups for 3 days.
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:54 AM To: Trudy Guest Subject: Re: [Tessitura Technical Forum] Transaction log is full - how to fix this?
Just to add to this:
Under Properties > Options the Recovery model is set to Full
Under General the last database backup is 12/2/2011 (last time we refreshed). Under Transaction Log shipping everything is greyed out so I guess that means it’s not actually doing anything.
On a side note, how do others manage their Test database in terms of backups, if at all?
From: Natasha Purkiss <bounce-natashapurkiss5883@tessituranetwork.com> Sent: 8/29/2012 10:26:47 AM
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!
It's working!!!
Thanks so much both of you!
I think I will try and set this up as you suggested Trudy.