SQL - Move database files to a new location

• Moving the TEMPDB
• http://www.sqlteam.com/article/moving-the-tempdb-database

USE master
GO
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'C:\tempdb2005.mdf') GO
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'C:\tempdb2005.ldf') GO

• Moving a regular DB
• http://codesnip.net/move-data-files-sql-server-mdf-ldf/
• Detach db
• Move files to new location
• Attach db

use master
go
sp_detach_db MYDB
use master
go
sp_attach_db MYDB, 'D:\data\mydb.mdb', 'E:\log\mydb.ldb'