Created
February 13, 2019 20:48
-
-
Save petesql/18847dc8625e60fdb6466d804f350e3e to your computer and use it in GitHub Desktop.
move_temp_db_files
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Move TempDB Files. | |
USE tempdb | |
GO | |
-- Get logical file names. | |
EXEC sp_helpfile | |
-- Move data files. | |
ALTER DATABASE tempdb MODIFY FILE ( | |
NAME = 'tempdev', | |
FILENAME = 'c:\sql_temp\tempdb.ndf') | |
ALTER DATABASE tempdb MODIFY FILE ( | |
NAME = 'temp2', | |
FILENAME = 'c:\sql_temp\tempdb2.ndf') | |
ALTER DATABASE tempdb MODIFY FILE ( | |
NAME = 'temp3', | |
FILENAME = 'c:\sql_temp\tempdb3.ndf') | |
ALTER DATABASE tempdb MODIFY FILE ( | |
NAME = 'temp4', | |
FILENAME = 'c:\sql_temp\tempd4.ndf') | |
-- Move og files. | |
ALTER DATABASE tempdb MODIFY FILE ( | |
NAME = 'templog', | |
FILENAME = 'c:\sql_temp\templog.ldf') | |
-- Restart SQL Service. | |
-- Verify change. | |
-- Delete old files. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment