![]() |
what is the method to change location of tempdb? |
|
|
1. Determine the logical file names of the tempdb database and their current location on the disk. SELECT name, physical_name FROM sys.master_files WHERE database_id = DB_ID('tempdb'); 2 Change the location of each file by using 3. Stop and restart SQL Server. 4. Verify the change Reference: Microsoft SQL Server Books Online |
|
Powered by
DBNest.com (Nest of DB Professionals)
