SQL SERVER 2005 用命令的方式还原Sql 2000 备份文件

use master
restore database [feifan] from disk = 'F:\Backup\Dat1106.dbk'
with replace,
MOVE N'feifan'
TO N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\feifan.mdf',
MOVE N'feifan_Log'
TO N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\feifan_log.ldf'

posted @ 2012-07-24 11:22 wangjt18 阅读(233) 评论(1) 收藏举报