Question

chuyen thư mục chứa data log sang vị trí khác

Answer 1

# xem duong dan
SELECT name,physical_name
FROM CXSRetail.sys.database_files;

# xem cac user dang truy cap
exec sp_who2

#chuyen mode single
ALTER DATABASE CXSRetail SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

# set offine
ALTER DATABASE CXSRetail SET OFFLINE;
 
# thay doi duong dan data
ALTER DATABASE CXSRetail MODIFY FILE
(
    NAME = CXSRetail_Data,
    FILENAME = 'D:\DATA_STORE\Data\DATA\CXSRetail_Data.mdf'
);

#that doi duong dan log
ALTER DATABASE CXSRetail MODIFY FILE
 (
    NAME = CXSRetail_log,
    FILENAME = 'D:\DATA_STORE\Log\DATA\CXSRetail_log.ldf'
);

# copy 2 file vao vi tri moi.
cmd
cp D:\DATA_STORE\Log\DATA\CXSRetail_Data.ldf
cp D:\DATA_STORE\Log\DATA\CXSRetail_log.ldf

#set lai online
ALTER DATABASE CXSRetail SET ONLINE;

#cho phep truy cap multi_user
ALTER DATABASE CXSRetail SET MULTI_USER;