QUERY TO CHANGE FILE LOCATION (ChangeLocation.sql) |
USE master go ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'R:\temp\tempdb.mdf') go ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'R:\temp\templog.ldf') go |
QUERY TO REPORT FILE LOCATION (MyReportScript.sql) |
SELECT name, physical_name FROM sys.master_files WHERE database_id = DB_ID('tempdb') go |
No comments:
Post a Comment