restore database error

  • Hi,

    While restoring database , I am getting the below error:

    restore database AdventureWorksDW2014

    from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL11.INST4\MSSQL\Backup\Adventure Works DW 2014 Full Database Backup\AdventureWorksDW2014.bak'

    with move 'AdventureWorksDW2014_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.INST4\MSSQL\DATA\AdventureWorksDW2014_Data.mdf',

    MOVE 'AdventureWorksDW2014_lOG' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.INST4\MSSQL\DATA\AdventureWorksDW2014_lOG.LDF',

    STATS = 10

    Error:

    Msg 3241, Level 16, State 0, Line 1

    The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL11.INST4\MSSQL\Backup\Adventure Works DW 2014 Full Database Backup\AdventureWorksDW2014.bak' is incorrectly formed. SQL Server cannot process this media family.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    Thanks.

  • are you restoring a 2014 database on a 2012 instance? that's the error i'd expect.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply