How to Restore Multiple BAK Files SQL Server?

Discussion in 'SQL Server' started by mac morley, Apr 1, 2014.

  1. mac morley

    mac morley New Member

    Joined:
    Apr 1, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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?
     
  2. john

    john New Member

    Joined:
    Apr 1, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  3. Jason Clark

    Jason Clark New Member

    Joined:
    Nov 18, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  4. vickya4n

    vickya4n New Member

    Joined:
    Aug 23, 2016
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Gender:
    Male
    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 ...
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice