RESTORE DATABASE NewDataBase
FROM DISK = 'C:\OldDataBase.bak'
with replace,
MOVE 'OldDataBase_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\NewDataBase_Data.MDF',
MOVE 'OldDataBase_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\data\NewDataBase_Log.LDF'
ALTER DATABASE NewDataBase
MODIFY FILE (NAME=OldDataBase_Data,NEWNAME=NewDataBase_Data)
ALTER DATABASE NewDataBase
MODIFY FILE (NAME=OldDataBase_Log,NEWNAME=NewDataBase_Log)
--备份数据库
BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
--恢复数据库到其它路径~
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'