Database Files in SQL Server 2005
The text of this article is not in this database — only its details are. Read it on the old site: Database Files in SQL Server 2005
2 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.
Martin GoebbelsPosted Jun 11, 2010, 8:18 AM
You said that "Transaction log files are not filled proportionally; instead, they fill each log file to capacity before continuing to the next log file." Well , i manage a sql 2000, and have a database with 3 log files equal size and i note that they are being filled equaly and when one grows the others do it too. It's a case of difference between sql 2000 and 2005, perhaps? Thanks in advance M.Goebbels
Maksuda HossaineditedPosted Jul 14, 2009, 4:22 PMEdited Jul 14, 2009, 4:22 PM
It's nice posting. I'm working with SQL 2005. My modellog.ldf file is getting bigger and bigger. it's a model db so no transaction is done here. Then why it's happening and how can I get rid of it ? Now it's size is more that 20 GB (it's mentioned in the log file property and I noticed it just now when I have the prob). Can I reduce my modelg.ldf file size and will it do any herm to my main db? Thanks in advance.