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
Hi Natasha,
Regarding backups for Test, I do create a daily backup. All my Dev work happens on Test, and I don’t want to lose anything in progress there. However, I have the Recovery model set to Simple so managing the trans log isn’t an issue.
Good luck!
Lori
From: Natasha Purkiss [mailto:bounce-natashapurkiss5883@tessituranetwork.com] Sent: Wednesday, August 29, 2012 11:55 AM To: Lori Field 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!