use master
BACKUP DATABASE NPU_Fulltext
TO DISK = ' D:\isaac\NPU_Fulltext.bak '
RESTORE FILELISTONLY
FROM DISK = ' D:\isaac\NPU_Fulltext.bak '
RESTORE DATABASE NFT_Fulltext
FROM DISK = ' D:\isaac\NPU_Fulltext.bak '
WITH MOVE ' NPU_Fulltext ' TO ' F:\NFT_Fulltext\NFT_Fulltext.mdf ', -- 注意这里的‘MYDB_Data’
MOVE ' NPU_Fulltext_log ' TO ' F:\NFT_Fulltext\NFT_Fulltext.ldf '
BACKUP DATABASE NPU_Fulltext
TO DISK = ' D:\isaac\NPU_Fulltext.bak '
RESTORE FILELISTONLY
FROM DISK = ' D:\isaac\NPU_Fulltext.bak '
RESTORE DATABASE NFT_Fulltext
FROM DISK = ' D:\isaac\NPU_Fulltext.bak '
WITH MOVE ' NPU_Fulltext ' TO ' F:\NFT_Fulltext\NFT_Fulltext.mdf ', -- 注意这里的‘MYDB_Data’
MOVE ' NPU_Fulltext_log ' TO ' F:\NFT_Fulltext\NFT_Fulltext.ldf '