I have a large virtual SQL Server (Full 2008R2).
I run 3 SQL instances and would like to relocate the TempdB database file to another location, splitting off from the TempdB log file.
The trouble I am having is that, even though the query
ALTER DATABASE executes successfully, and then restarting that particular instance's SQL Server Service, does not relocate that database file.
Do I have to restart the whole server to move this database?