如何在sqlserver 2008中恢复多个数据库文件（.bak） [英] how to restore multiple database file(.bak) in sqlserver 2008

问题描述

任何人都可以告诉我如何以正确的方式做到这一点

anybody can tell me how to do that in correct way

推荐答案

您可以使用SQL Query恢复.bak文件。因此，如果要恢复多个.bak文件，可以编写多个批次。您将找到如何从SQL 此处恢复数据库。

You can restore your .bak files using SQL Query. So If you want to restore multiple .bak files you can write multiple batches. You will find how to restore databases from SQL Here.

我正在尝试找到我几个月前发现的关于如何恢复由几个BAK文件组成的备份的脚本。对我来说，这似乎是OP提出的问题。我不是说上面提供的答案回答了这个问题。当然没有帮助我。

现在，这是一个老线程，但有人可能会偶然发现这一点，同时试图像我一样解决这个问题。我很幸运，因为我使用的是SQL Server 2014，并且能够使用GUI进行恢复，然后生成完成后使用的脚本。否则，需要花费几个小时才能找到它。

I was trying to find the script I found several months ago on how to restore a backup composed of several BAK files. To me it looks like this is the question posed by the OP. I do not that the answer provided above answers that question. Sure didn't help me.
Now, this is an old thread, but someone may stumble across this while trying to figure it out like I did. I was lucky in that I was using SQL Server 2014, and was able to use the GUI to do the restore, and which then generated the script it used after completion. Otherwise it would have taken several more hours to find this.

USE [master]
RESTORE DATABASE [ABC] 
FROM  DISK = N'C:\_D\DB_Backups\ABC1_20170731.bak',  
	  DISK = N'C:\_D\DB_Backups\ABC2_20170731.bak',  
	  DISK = N'C:\_D\DB_Backups\ABC3_20170731.bak',  
	  DISK = N'C:\_D\DB_Backups\ABC4_20170731.bak',  
	  DISK = N'C:\_D\DB_Backups\ABC5_20170731.bak' 
WITH  FILE = 1,  
MOVE N'ABC_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.[instancename]\MSSQL\DATA\ABC.MDF',  
MOVE N'ABC_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.[instancename]\MSSQL\DATA\ABC.LDF',  

NOUNLOAD,  
STATS = 5

GO

这篇关于如何在sqlserver 2008中恢复多个数据库文件（.bak）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！