如何将数据库恢复到特定文件夹

本文关键字：文件夹 恢复 数据库 | 更新日期: 2023-09-27 18:29:04

我在中有数据库备份文件

D： ''Prabhagar''Projects''ZIP ''Priya DB''Backups''Sample.bak

当我恢复时，它将恢复到

C： ''Program Files''Microsoft SQLServer''MSSQL11.SQLEXPRESS12''MSSQL''DATA

这个目录。但我想恢复到

D： ''Prabhagar''Projects''ZIP ''Priya DB''Backups''TestDB''

我该怎么办？我使用了以下查询

从磁盘恢复数据库backup_lookup='D:''Prabhagar''Projects''ZIP ''Priya DB''Backups''Sample.bak.'

请帮帮我。谢谢

如何将数据库恢复到特定文件夹

尝试以下命令。

RESTORE DATABASE backup_lookup FROM DISK = 'D:'Prabhagar'Projects'ZIP'Priya DB'Backups'Sample.bak' 
WITH REPLACE, 
MOVE 'backup_lookup_DATA' TO 'D:'Prabhagar'Projects'ZIP'Priya DB'Backups'TestDB'backup_lookup.mdf', 
MOVE 'backup_lookup_LOG' TO 'D:'Prabhagar'Projects'ZIP'Priya DB'Backups'TestDB'backup_lookup_1.ldf'

正如您可以尝试的那样：

RESTORE DATABASE Sample FROM DISK = 'D:'Prabhagar'Projects'ZIP'Priya DB'Backups'Sample.bak'
WITH MOVE 'Sample_Data' TO 'D:'Prabhagar'Projects'ZIP'Priya DB'Backups'TestDB'Sample_Data.mdf',
MOVE 'Sample_Log' TO 'D:'Prabhagar'Projects'ZIP'Priya DB'Backups'TestDB'Sample_Log.ldf',
NORECOVERY
GO
RESTORE LOG Sample FROM DISK = 'D:'Prabhagar'Projects'ZIP'Priya DB'Backups'TestDB'Sample.TRN'
GO
相关文章：