hello, Is it pssible to move tempdb to anorhter location (another physical disc)? I thought that I can simply dettach it and attach it to another location, but it does not allow. thanks
Yes you can and refer to this KBAhttp://support.microsoft.com/support/kb/articles/Q187/8/24.asp for more information. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.