MSSQL/tempdb_resize.txt at master · petjak/MSSQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
USE [master]
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev2', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev3', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev4', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev5', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev6', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev7', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev8', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev9', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev10', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev11', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev12', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev13', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev14', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev15', SIZE = 20971520KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev16', SIZE = 20971520KB )
GO

--##########################################################################--

USE [master]
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev2', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev3', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev4', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev5', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev6', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev7', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev8', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev9', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev10', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev11', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev12', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev13', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev14', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev15', FILEGROWTH = 1048576KB )
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev16', FILEGROWTH = 1048576KB )
GO