Home Forums SQL Server 2005 Administering Transaction is taking more space after shrinking also RE: Transaction is taking more space after shrinking also
Suresh B.
SSC-Insane
Points: 22986
More actions
June 4, 2008 at 12:40 am
#824002
>>after some hours log file size increases about more than 2gb. Thats the issue.
May be, there are so many transactions. Check it with Profiler.
Don't shrink the log file, unless you have shortage of free space.
What is the data and log file size?