Experts Exchange connects you with the people and services you need so you can get back to work.

Log file is too large than data file

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

jjjosef

Asked: 2012-12-26

Advertise Here

Microsoft SQL Server 2008

1 Solution

LVL 39

Pratima PharandeCommented: 2012-12-26

refer
http://msdn.microsoft.com/en-us/library/ms178037(v=sql.105).aspx

LVL 39

Pratima PharandeCommented: 2012-12-26

see this also

http://www.codeproject.com/Articles/261132/Truncate-Shrink-Transaction-Log-files-on-SQL-Serve

LVL 2

RRobinhoCommented: 2012-12-27

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Log file is too large than data file

Join & Write a Comment Already a member? Login.

Featured Post