oraclespin.com
How to move tempdb database files and user databases to new location?
Using the steps below one can change the location of the datafiles in SQLServer for user databases and tempdb. 1) First find the current location of the filename and name: select name, filename fro…