SQL Server Developer Center >
SQL Server Forums
>
Getting started with SQL Server
>
Moving Tempdb in SQL 2008 multi instance server
Moving Tempdb in SQL 2008 multi instance server
- I am trying to move the tempdb dB and log files using the alter database command but I get an error that the file location is invalid. I checked the folder path and its OK and I have Full NTFS control over the folder. Does anyone have this issue? The instance that is running is correct as well.
Thanks
Answers
>> I have Full NTFS control over the folder
It does not matter permission you have its the SQL Server service account that need permission. Please check and confirm account under which sql server service is running can access the new file location.
Please refere to following (look under moving tempdb)
http://support.microsoft.com/default.aspx/kb/224071- Proposed As Answer byChunSong Feng -MSFTMSFT, ModeratorMonday, November 09, 2009 9:32 AM
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorWednesday, November 11, 2009 11:48 AM
All Replies
>> I have Full NTFS control over the folder
It does not matter permission you have its the SQL Server service account that need permission. Please check and confirm account under which sql server service is running can access the new file location.
Please refere to following (look under moving tempdb)
http://support.microsoft.com/default.aspx/kb/224071- Proposed As Answer byChunSong Feng -MSFTMSFT, ModeratorMonday, November 09, 2009 9:32 AM
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorWednesday, November 11, 2009 11:48 AM
