--turn off autogrowth
USE master
GO
ALTER DATABASE db_Name
MODIFY FILE
(NAME = db_Name,
FILEGROWTH = 0MB)
GO
--turn on autogrowth
USE master
GO
ALTER DATABASE db_Name
MODIFY FILE
(NAME = db_Name,
FILEGROWTH = 10MB)
GO
USE master
GO
ALTER DATABASE db_Namelog
MODIFY FILE
(NAME = db_Namelog,
FILEGROWTH = 0MB)
GO
--turn on autogrowth
USE master
GO
ALTER DATABASE db_Namelog
MODIFY FILE
(NAME = db_Namelog,
FILEGROWTH = 10MB)
GO