Fellow DBa's
I need to move tempdb and reset the inital size - my growth is fine. Obviously both of these require a restart.
My questions are:
1 - Can I do these all in the same batch of commands, like below, and do one restart. Or do one set (location change), restart and then another set (initial size) and restart.
2 - Does it matter which goes first: init and location move or location move and then init.
Was planning to to the below in this exact order with just one reboot for all of it.
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = 'M:\MSSQL\DATA\tempdb.mdf');
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = 'M:\MSSQL\DATA\templog.ldf');
GO
ALTER DATABASE tempdb MODIFY FILE
(NAME = 'tempdev', SIZE = 1024)
GO
ALTER DATABASE tempdb MODIFY FILE
(NAME = 'templog', SIZE = 1024)
GO
thx MG
