We are unable to launch Tessi, The error is "transaction log for database impresario is full".. We had an error with our backup last night, but I dont see why that should be causing this issue.
How do I resolve this and get Tessi back online? Ideas?
AH- partition was filling up, no space. I purged the "weeds" and all is good...
Glad you fixed your problem. The logs normally get truncated when the backups run. If your backups failed that would explain your logs filling up their available disk space. You should consider moving your logs to a location with more disk space though. If one night of failed backups caused the logs to grow to a point where they filled the disk you have a potential of seeing the same problem on a high sales day and that would be the last thing you would want.
-Rich
Is there a safe way to truncate or shrink the ldf? Right now the ldf is about 42GB.. which seems just huge...
There are two ways to do that.
Before you do this have the database in SIMPLE RECOVERY MODEL.
1) sql server management studio - > right click on the database -> tasks -> shrink file.
The available free space must be as high as possible,initially release the space a see what happens.Then shrink the file to the size you want it to be.
2) sp_helpfile -- command to check the actual size DBCC Shrinkfile( ldf - file id, file size you want to shrink)
I followed the same steps when we ran into this kind of issue and things went pity fine.
This should stabalize once you start taking the transactional log backups.
Caution: Just have the full backup before doing anything just incase.