0

I just had a problem : days ago, on one of my client's databases, the LDF file suddenly grew up to 100% of the disk capacity.

.TRN backups are correctly done every 15min (I don't think reducing this time will help, because this database is rarely used).

I created this database from a backup, two months ago. Everything was OK.

What I didn't understood, is why the "initial size" of the LDF file was... 512GB, which is the size of the disk... If the initial size had been like that since the first restore, i would have noticed it. So I'm certain that it was not the case.

What I did : backup, simple mode, reducing initial size (it reduced the file size without shrink), full mode, backup.

It's OK now, but i'd like to understand if the "initial size" can change automatically, and if yes, how to prevent it.

Thanks!

2
  • Check this dba.stackexchange.com/questions/29829/… – vijayp Oct 10 '14 at 11:46
  • I checked this post before posting, but my question was not about this incontrollable growth, but about the initial size, which was wrong but was OK when the database was created. – Patator Oct 10 '14 at 12:00
2

There is nothing that allows SQL Server to modify the initial size of a file automatically, by itself.

The file must have been altered by a sysadmin or someone with ownership of the database.

I expect they were setting the max size of the file and set the wrong option.

1
  • ok, thanks. Sadly i'll never know who did that :( – Patator Oct 10 '14 at 16:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.