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?
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 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
Seeking to restore from multiple bak files to a test SQL database ... be able torestore these four backups into a different database on the server ...