How to move SQL Server Database MDF/LDF files to new location (change database location)
http://bit.ly/it-solutions-subscribe ### Subscribe ###
Steps.
Find database name / logical database name and file location.
Modify file location using commands.
Move physical files (mdf + ldf or just mdf if database is in simple mode)
Set database OFFLINE and ONLINE
ALTER DATABASE DBName
MODIFY FILE ( NAME = DBLogicalName_Data,
FILENAME = 'E:\New_location\DBName_Data.mdf');
GO
ALTER DATABASE DBName
MODIFY FILE ( NAME = DBLogicalName_Log,
FILENAME = 'E:\New_location\DBName_Log.ldf');
GO
ALTER DATABASE DBName SET OFFLINE;
GO
ALTER DATABASE DBName SET ONLINE;