【例11-10】.txt

sql server 2000 数据库与应用

【例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