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
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?