Home / server / Questions / 142750
Accepted
Ddono25
Asked: 2010-05-18 12:25:30 +0800 CST

T-SQL for autogrowth of multiple data files

  • 772

I can't seem to figure out the problems with my script to alter SQL Server 2008 database and file growth. There are two data files and a log file, all which need to have Autogrowth ON. Does this look completely wrong? Thanks!

USE MASTER
GO
ALTER DATABASE BigDB
MODIFY FILE
( NAME = BIGDBPPE,
FILENAME = "H:\MSSQL\Data\BigDB.mdf",
MAXSIZE = UNLIMITED,
FILEGROWTH = 2000MB)

USE MASTER
GO
ALTER DATABASE BigDB
MODIFY FILE
( NAME = BIGDBPPE1,
FILENAME = "K:\MSSQL\Data\BigDB_data1.ndf",
MAXSIZE = UNLIMITED,
FILEGROWTH = 2000MB)

USE MASTER
GO
ALTER DATABASE BigDB
MODIFY FILE
( NAME = BIGDBPPE_log,
FILENAME = "O:\MSSQL\Data\BigDB_log.ldf",
MAXSIZE = UNLIMITED,
FILEGROWTH = 200MB)
GO
sql-server sql-server-2008 tsql

1 Answers

  1. Best Answer

    The syntax looks ok, make sure the database name doesn't need to be [square-bracketed] and that the logical names match.

    • 1