Reduce Log File Size

Question

Post reply

Reduce Log File Size

Gaurav Srivastava

Mr or Mrs. 500

Points: 571
More actions
June 11, 2014 at 9:33 pm

#396900

How can i reduce my Sql database .LDF file size.
Even i set Auto Shrink Property is True
da.mdf Size is 15.25 MB
da_log.ldf size is 128.00 MB.
I am using Sql Server 2008 and database is updated from 2005 to 2008 Sql Server.
In case any Issue Of Version.
June 12, 2014 at 9:52 pm

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 1

Eirikur Eiriksson

SSC Guru

Points: 182882

June 12, 2014 at 1:07 am

#1720940

What is the Recovery Model for the database?

😎

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

First thing you can do is turn autoshrink off. That's a setting which should never be enabled.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Convery SSCrazy Points: 2159 More actions · Answer 3

@itsgaurav

Can you please post your questions on the correct forums for the SQL Server version you're using? It will make it easier for you to get answers and we won't have to keep moving them. Thanks.

Grant Fritchey SSC Guru Points: 398694 More actions · Answer 4

Are you running log backups?

[/url]

And, I'm with Gail, turn off auto shrink.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gaurav Srivastava Mr or Mrs. 500 Points: 571 More actions · Answer 5

At First Thanks For Reply

My Sql Server Version is :

Recovery Model : Full

Compatibility Level : Sql Server 2008 (100)

Now I Set Auto Shrink Property Is Off.

After That I have To do something or it will auto reduce kindly suggest ?

Grant Fritchey SSC Guru Points: 398694 More actions · Answer 6

Did you read the post I linked to? You need to have log backups enabled.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning