DatabaseName: CND (example)
NewPathNameData: C:\DATA1\
NewPathNameLog: C:\LOG\
checking to Database PathLocation:
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID(N'CND');
use master
go
ALTER DATABASE CND
MODIFY FILE ( NAME = CND,
FILENAME = 'C:\DATA1\CND.mdf');
GO
ALTER DATABASE CND
MODIFY FILE ( NAME = CND_log,
FILENAME = 'C:\LOG\CND_Log.ldf');
GO
ALTER DATABASE CND SET OFFLINE;
GO
move data (*.mdf and *.ldf ) to new location (as phisical) "like copy and past to new location etc."
ALTER DATABASE CND SET ONLINE;
GO
checking to New Database PathLocation:
SELECT name, physical_name AS NewLocation, state_desc AS OnlineStatus
FROM sys.master_files
WHERE database_id = DB_ID(N'CND')
GO
