|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
![]() |
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 |
||||
| Others in this Category | |
| What is Data Mapping | |
| What is an Ad Hoc Query? | |
| How to know which index a table is using? | |
Powered by
DBNest.com (Nest of DB Professionals)
