SQL2005/2008 备份还原数据库并重命名
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'
在编程的道路上,一往无前,埋头狂奔。
[奔跑的人生] | [segmentfault] | [spring4all] | [csdn] | [掘金] | [OSChina] | [简书] | [知乎] | [51CTO]
[奔跑的人生] | [segmentfault] | [spring4all] | [csdn] | [掘金] | [OSChina] | [简书] | [知乎] | [51CTO]