User Profile

Collapse

Profile Sidebar

Collapse
digitecht
digitecht
Last Activity: Jul 1 '17, 08:47 PM
Joined: Jun 30 '17
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • 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
    ...
    See more | Go to post

    Leave a comment:


  • digitecht
    started a topic Unable to move Tempdb files to another drive

    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.
    See more | Go to post
No activity results to display
Show More
Working...