January 26, 2006 at 10:07 am
Hi,
does anyone know how to move the tempdb to another drive/folder in a cluster environment? the usual alter database does the trick, but when stopping sql server and trying to start, it WON'T start. I can't find anything specific to cluster environment. If anyone has dealt with this, please shed some light.
Thank you
January 26, 2006 at 1:39 pm
That should work, there is nothing about a cluster that changes the nature of tempdb.
The only possibility I can think of is that you should verify that the volume to which you moved tempdb is a cluster resource and that the SQL Server resource is dependent on it.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 27, 2006 at 7:25 am
Assuming you used this proc from BOL, the filename needs to be modified to 'E:\SQLData\tempdb.mdf', same for log. Otherwise as dcpeterson described!
USE tempdbGOEXEC sp_helpfileGO--The logical name for each file is contained in the NAME column.USE masterGOALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'E:SQLData\tempdb.mdf')GOALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'E:SQLData\templog.ldf')GOJanuary 27, 2006 at 8:34 am
This may be a stupid comment, but you must be sure you are moving it to a clustered resource, not a local drive.
Terry.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply