SSAS: Move tempdb database

ssas

For SQL server 2008 R2 Analysis services, how can I move tempdb database files from one drive to another? At the time of installation, I didn't have a separate drive for tempdb. Now that I do have one, I need to move to the new drive.

Best Answer

You need to alter the location using ALTER DATABASE tempdb MODIFY FILE location and restart SQL Server. SQL Server will automatically create the tempdb in the new location but you may have to go to the old location to delete the (old) files.

See Moving the tempdb database in http://msdn.microsoft.com/en-us/library/ms345408.aspx

Related Question