locked
Restore SQL server files RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    I had a SCOM server that crashed.

    I have a backup of  the SQL server Data on a DPM server 2012 r2.

    I have recovered the data to a network share.
    I have reinstalled the SCOM server.

    I am trying to restore the data to the new SCOM  server.

    If I Try to restore Database I am unable to restore.

    If I try to restore files and file groups ,From device  and I select the MDF file I gent an error The media family is incorrectly formed. Error 3241.

    I cannot restore directly from the DPM Sever.

    Thanks

    Itamar

    Itamar

    Thursday, February 25, 2016 1:28 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    From device  and I select the MDF file I

    Hello Itamar,

    In common the file Extension of a backup file is .BAK

    A MDF is a database file, which can be attached to SQL Server, see Attach a Database

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by FLauffer Thursday, February 25, 2016 1:42 PM
    • Marked as answer by Eric__Zhang Monday, March 7, 2016 12:59 PM
    Thursday, February 25, 2016 1:36 PM