Unanswered: What should I do with the huge log file
I found my database log file is 26GB and the database file is just about 280MB. We are doing full backup everyday. However, my sql server seems running very slow now and please advise:
1. How can I decrease/truncate my log file?
2. Would the huge size of the log file be the reasons slowing up my sql server?
3. Would anyone give me direction knowing more on the transaction log?
Thank you and appreciated!
1. From EM rightclick the database, choose 'All' and 'Shrink database'. If it doesnt help, see BOL for "DBCC SHRINKDATABASE" and "BACKUP LOG".
2. Perhaps if your disk capacity is limited, the os might have difficulty finding free space. If various large transactions are rollbacked, that could have an affect on performance.
3. My guess is that you refer to what's inside the transaction log and how did it become so big. I know there are some tools that allow you to see what' inside, don't remeber the url though. Perhaps the sql-profiler can help you more as to find out what transactions grow the log.