RESTORE DATABASE DBName
FROM DISK = 'D:\Backup\OtherDBName_backup_201303012100.bak'
with
move 'DBName' to 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DBName.mdf',
move 'DBName_log' to 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DBName_log.ldf',
NoRecovery,
Replace
go
沒有留言:
張貼留言