![]() ![]() All you have to do is update the file location of each of the log and datafiles (In this case for simplicity we only have 2 data files and 1 log file) as follows although you may have more:ĪLTER DATABASE MODIFY FILE (NAME = tempdev, FILENAME = 'M:\Tempdb\tempdb.mdf') ĪLTER DATABASE MODIFY FILE (NAME = templog, FILENAME = 'M:\Tempdb\templog.ldf') ĪLTER DATABASE MODIFY FILE (NAME = temp2, FILENAME = 'M:\Tempdb\tempdb2.ndf') In order to move TempDB, please follow the steps below:Īs TempDB is recreated every time SQL server restarts, moving it is reasonably easy. This will show you where all of your system database files are at the time of execution as well as the command to put them back to their original location (The output of this is worth saving). ![]() ORDER BY database_id ASC, type_desc DESC
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |