My transaction log file status is as following 117 MB USED 10315 MB FREE iam using Full recovery model Please tell me How can i regain this transaction log's free space. without affecting the performance and while transactions are running.
I believe this is a duplicate post from your previous post - http://sql-server-performance.com/Community/forums/p/25335/140423.aspx#140423 and refer to the link over there that will guide you through.