Search

Wednesday, July 27, 2011

Out of disk space due to auto growth

There is a bug in some applications and also in some pathces from Microsoft that can change the max growth rate for a databasefile to more than 100%.

I had three servers with databases that had a growth rate of more than 12000%. This can not be fixed via the gui so you have to use code, E.g.

USE master;
GO
ALTER DATABASE EBD_EBOEU
MODIFY FILE
(NAME = EBD_EBOUSA_Data,
FILEGROWTH = 100MB);
GO

Once that is done the file can be shrunk and the problem is solved.

No comments:

Post a Comment