USE master
RESTORE DATABASE [数据库名称]
FROM DISK = '数据库备份路径'
WITH MOVE '数据库备份的数据库名称' TO '数据库文件',
MOVE '数据库备份的数据库日志文件' TO '数据库日志文件',
STATS = 10, REPLACE
GO
例:
USE master
RESTORE DATABASE DBnew
FROM DISK = 'E:/db_back.Bak'
WITH MOVE 'Test' TO 'E:/Program Files/Microsoft SQL Server2005/Data/DBnew.mdf',
MOVE 'Test_log' TO 'E:/Program Files/Microsoft SQL Server2005/Data/DBnew_log.ldf',
STATS = 10, REPLACE
GO
RESTORE DATABASE [数据库名称]
FROM DISK = '数据库备份路径'
WITH MOVE '数据库备份的数据库名称' TO '数据库文件',
MOVE '数据库备份的数据库日志文件' TO '数据库日志文件',
STATS = 10, REPLACE
GO
例:
USE master
RESTORE DATABASE DBnew
FROM DISK = 'E:/db_back.Bak'
WITH MOVE 'Test' TO 'E:/Program Files/Microsoft SQL Server2005/Data/DBnew.mdf',
MOVE 'Test_log' TO 'E:/Program Files/Microsoft SQL Server2005/Data/DBnew_log.ldf',
STATS = 10, REPLACE
GO