How to Restore Multiple BAK Files SQL Server?

mac morley's Avatar, Join Date: Apr 2014
Newbie Member
I m working on SQL Server version 2012 and my backup database has got damaged suddenly. Please solve my query that how to restore multiple bak files sql server?
0
john's Avatar, Join Date: Apr 2014
Newbie Member
well mac I do have solution for your query that how to restore multiple bak files of sql server. Only u need to type this keyword "restore corrupt sql backup" on the google search engine and u will find result on first rank.
0
Jason Clark's Avatar, Join Date: Nov 2015
Newbie Member
you can run the below script for getting the logical names for database data and log files

Code:
RESTORE FILELISTONLY FROM
DISK =  'D:\DBBackups\ReportServer\ReportServer.bak'
GO
then put logical file names in script below:

Code:
RESTORE DATABASE ReportServerComplteCopy FROM
DISK = 'D:\DBBackups\ReportServer\ReportServer.bak'
WITH REPLACE ,
MOVE 'ReportServer' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER11\MSSQL\DATA\ReportServerComplteCopy.mdf',
MOVE 'ReportServer_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER11\MSSQL\DATA\ReportServerComplteCopy_log.ldf'
GO