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?
How to Restore Multiple BAK Files SQL Server?
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.
you can run the below script for getting the logical names for database data and log files
then put logical file names in script below:
RESTORE FILELISTONLY FROM DISK = 'D:\DBBackups\ReportServer\ReportServer.bak' GO
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