Definitions More Info.
Definition ID	2.022
Title	SQL
Category	NOTES
Definition	tempdb Yerdegistirme
Definition Description	https://www.brentozar.com/archive/2017/11/move-tempdb-another-drive-folder/ NOT: ASAGIDAKI SORGU SONUCUNDA CIKAN FILENAME ADLARINI DEGISTIRMEYI UNUTMA !!!!! SELECT 'ALTER DATABASE tempdb MODIFY FILE (NAME = [' + f.name + '],' + ' FILENAME = ''Z:\MSSQL\DATA\' + f.name + CASE WHEN f.type = 1 THEN '.ldf' ELSE '.mdf' END + ''');' FROM sys.master_files f WHERE f.database_id = DB_ID(N'tempdb');
RecordBy	cunay
Record Date	02-05-2020 14:01:44
Düzenle
Kopyala
Sil