Changing logical names and physical file names of SQL Server database | Saji Viswam's Blog

ALTER DATABASE database name MODIFY FILE (NAME="logical_name", FILENAME="C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\new_file_name_you_want.mdf")

sajiviswam.wordpress.com