September 24, 2008 at 8:37 am
I need to know if someone shrinks the transaction log, is it logged anywhere?
We had a log yesterday that was shrunk to 2mb from 5gb and I need to know when it was done.
I would swear that I didn't do it, but all evidence points to me doing it. :crying:
The main data file was 41gb and I shrunk it down to 40gb. I do not remember doing anything that would have shrunk the log file from 5gb to 2mb.
September 24, 2008 at 8:44 am
Oh yea, I forgot to say that I have looked through the application log, system log and event log in windows.
I have also scanned through the Sql server log.
The one place that could have told me the time/date it was done was the timestamp on the log file. I increased the size of the log to get the daily jobs going before I checked the date, so that date was lost.
October 2, 2008 at 2:32 pm
When you do a truncate log command it is logged in the windows event log viewer in the application log.
Hope this helps
October 3, 2008 at 6:41 am
Thanks for the reply, but I was asking about shirinking, not truncating. I have also already looked through the event, application and system logs and found nothing.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply