June 17, 2011 at 8:57 am
My database is in SIMPLE mode.
It is a restore of a client site database which I am testing indexes on.
I add 20 indexes and the .LDF file grows to 2GB.
Why is this?
I thought running in SIMPLE recovery mode on my development server would mean the LDF would not grown in this way.
any thoughts / explanation greatly appreciated.
r
June 17, 2011 at 9:14 am
When in simple recovery, your log file will grow if there is not enough space in the file to support active transactions. Once those transactions are committed, the file will clear through a checkpoint to a certain point but that file will not shrink.
What you are seeing is normal behavior.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 17, 2011 at 9:18 am
Thank you Jason
So if I presize database MDF file this should not happen?
I did advise presizing data files a while ago but the message got lost somewhere.
Big thank you
I will test straight away.
r
June 17, 2011 at 9:30 am
Presize the mdf will not affect the LDF / Log. Presize the Log file too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply