October 24, 2013 at 3:47 am
Hi All,
I want to movie Tempdb files to different disk say from A to B while SQL server is down.
When I restart SQL server will it pickup new location (B) for tempdb?
Thanks in advance
October 24, 2013 at 4:09 am
Sqlsavy (10/24/2013)
I want to movie Tempdb files to different disk say from A to B while SQL server is down.When I restart SQL server will it pickup new location (B) for tempdb?
NO.
See this link http://blog.sqlauthority.com/2007/04/01/sql-server-tempdb-is-full-move-tempdb-from-one-drive-to-another-drive/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 4:28 am
thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply