Restore Problem Urgent

  • When Im restoring the database im getting following error

    Msg 3132, Level 16, State 1, Line 1

    The media set has 2 media families but only 1 are provided. All members must be provided.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    How to solve above problem ,Plz give me solution urgent

  • The error message says the while backing up the database, more than one file names were specified which means the backup was stripped, meaning backup of the database were taken in more than one file.

    Hence, while restoring the database, you must provide all the backup files instead of providing just one file.



    Pradeep Singh

  • The backup in question has been striped across two files, with half the backup in each one. This commonly happens by accident when backing up through management studio. If there are two files in the backup database dialog, the backup goes across both, not to theone selected.

    The only way to resolve this is to find the other file. With only one of the two files, you only have half of the database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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