27,579
社区成员
发帖
与我相关
我的任务
分享
Step 1: offline
alter database [test_leo] set offline
Step 2: modify
USE master;
GO
ALTER DATABASE test_leo
MODIFY FILE
(
NAME = test_leo,
FILENAME = N'E:\Data\test_leo.mdf'
);
GO
ALTER DATABASE test_leo
MODIFY FILE
(
NAME = test_leo_log,
FILENAME = N'E:\Data\test_leo_log.LDF'
);
GO
Step 3:Move files
physically move the file from the orginal directory to the new directory
Step 4: online
alter database [test_leo] set online