Skip to content

Instantly share code, notes, and snippets.

@rheid

rheid/addFileToTempDB.sql

Created September 4, 2014 08:00
Show Gist options
  • Save rheid/bfdc8037cd1983260516 to your computer and use it in GitHub Desktop.
Save rheid/bfdc8037cd1983260516 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server TempDB with multiple Files
Raw
addFileToTempDB.sql
ALTER DATABASE [tempdb]
MODIFY FILE ( NAME = N'tempdev' , SIZE = 3480000KB )
ALTER DATABASE [tempdb]
ADD File ( NAME = N'tempdev_2', FILENAME = N'G:\database\tempdev_2.ndf' , SIZE = 3480000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB)
ALTER DATABASE [tempdb]
ADD File ( NAME = N'tempdev_3', FILENAME = N'G:\database\tempdev_3.ndf' , SIZE = 3480000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB)
ALTER DATABASE [tempdb]
ADD File ( NAME = N'tempdev_4', FILENAME = N'G:\database\tempdev_4.ndf' , SIZE = 3480000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB)
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment