Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* Re-sizing TempDB to 15 GB */
- USE [master];
- GO
- alter database tempdb modify file (name='tempdev', size = 15GB);
- GO
- USE [master];
- GO
- ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev2', FILENAME = N'D:\data\tempdev2.mdf' , SIZE = 15GB , FILEGROWTH = 0);
- ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev3', FILENAME = N'D:\data\tempdev3.mdf' , SIZE = 15GB , FILEGROWTH = 0);
- ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev4', FILENAME = N'D:\data\tempdev4.mdf' , SIZE = 15GB , FILEGROWTH = 0);
- ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev5', FILENAME = N'D:\data\tempdev5.mdf' , SIZE = 15GB , FILEGROWTH = 0);
- ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev6', FILENAME = N'D:\data\tempdev6.mdf' , SIZE = 15GB , FILEGROWTH = 0);
- ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev7', FILENAME = N'D:\data\tempdev7.mdf' , SIZE = 15GB , FILEGROWTH = 0);
- ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev8', FILENAME = N'D:\data\tempdev8.mdf' , SIZE = 15GB , FILEGROWTH = 0);
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement