Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   How to Restore Multiple BAK Files SQL Server? (http://www.go4expert.com/forums/restore-multiple-bak-files-sql-server-t30041/)

mac morley 1Apr2014 11:52

How to Restore Multiple BAK Files SQL Server?
 
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?

john 1Apr2014 17:25

Re: 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.

Jason Clark 18Nov2015 13:58

Re: How to Restore Multiple BAK Files SQL Server?
 
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



All times are GMT +5.5. The time now is 03:45.