【例11-10】.txt

来自「sql server 2000 数据库与应用」· 文本 代码 · 共 12 行

【例11-10】还原数据库并将文件移动至C：\下的指定位置
USE MASTER
GO
RESTORE DATABASE XSCJ
FROM datbackup
WITH NORECOVERY, 
MOVE 'XSCJ_data' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\XSCJ_data.mdf',
MOVE 'XSCJ_log' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\XSCJ_log.ldf'
RESTORE LOG XSCJ
FROM data_backup
WITH RECOVERY