相关代码 |
|
【例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