Figured it out. I thought you had to copy the tempdb files first to the new location then run the tsql script to recognize the new location. I just ran the following script to point to the new location and the files move automatically to the new share drive location.
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = 'T:\MSSQL12.SVT _CLUST\MSSQL\Da ta\tempdb.mdf') ;
GO
...
User Profile
Collapse
Profile Sidebar
Collapse
digitecht
Last Activity: Jul 1 '17, 08:47 PM
Joined: Jun 30 '17
Location:
-
Unable to move Tempdb files to another drive
Whenever I attempt to copy my tempdb files over to another drive, I get the message "The action can't be completed because the file is open in SQL SERVER(Abc_CLUS T). Close the file and try again. Any ideas? Running sql 2014 in a clustered environment. I failed over and restarted/shutdown the cluster nodes and still get the same message.
No activity results to display
Show More
Leave a comment: