Log file is too large than data file

jjjosef
jjjosef used Ask the Experts™
on
There is Log file is too large than data file..

What would be the best way to shrink log file in SQL server

The transaction logs are too large, a s I noticed log file size is very large compared to data file & major problem is that the transaction log is continuing to grow

I am looking for a recommended solution to shrink our transaction logs
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
If you are in FULL recovery mode; database log will continue to grow unless you backup the transaction log

If you do not need point in time recovery, you may to switch to simple recovery mode

Also Rebuilding the index may cause this. Use SORT_IN_TEMPDB option when rebuilding indexes

Refer the article in case

MSDN Library

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial