在sql server中可以设定备份任务
备份出 .bak文件
restore 到一个新的database系统中
步骤:
1.create database newname
2.restore file
Restore FILELISTONLY FROM DISK='d:/Business_Data.bak'
3.restore database
RESTORE DATABASE Business_Data_TSQL
FROM DISK='d:/Business_Data.bak'
WITH
MOVE 'Business_Data' TO 'D:/TSQL/Business_Data.mdf',
MOVE 'Business_Data_log' TO 'D:/TSQL/Business_Data_log.ldf'