Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
The media set has 2 families

已答复 The media set has 2 families

  • Wednesday, July 04, 2012 6:18 AM
     
     
    Sign In to Vote
    0

    Hi Everyone ,

                I tried all the solutions posted over here , but getting the error as below.

    Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.AM2\MSSQL\Backup\rtc.bak'. Operating system error 2(failed to retrieve text for this error. Reason: 15105).

    please someone help me to solve this.

     

All Replies

  • Wednesday, July 04, 2012 6:36 AM
    Moderator
     
     
    Sign In to Vote
    0

    Your text in the post doesn't seem to match the subject of the post. Also, I don't know what "all the solutions posted over here refers to. Anyhow, the operating system error code 2 means "Cannot find the file specified". So, it seems there is no file named rtc.bak on the SQL Server machine in that path.

    Tibor Karaszi, SQL Server MVP | web | blog

     
  • Wednesday, July 04, 2012 9:20 AM
     
     
    Sign In to Vote
    0

    Manually browse the directory to check the backup file, I think either file not exits or path is incorrect

    'C:\Program Files\Microsoft SQL Server\MSSQL10_50.AM2\MSSQL\Backup\rtc.bak'

     
  • Thursday, July 05, 2012 7:46 AM
     
     
    Sign In to Vote
    0

    SQL Server Service account is not having permission on this particular file.

    Secondly i believe you are getting this error while restoring the backup file.

    you can add your sql server service account to your administrator users.

     
  • Friday, July 06, 2012 3:26 PM
     
     Answered
    Sign In to Vote
    0

    If your problem is actually the title you give "The media set has 2 families" then:

    1. This tells you that the backup you are trying to restore was written to two files.  You need both files to do a restore. If you only have 1 file, then you do not have a restorable backup.
    2. As pointed out above, the "rtc.bak" is not in the listed location.  However, it may be that the .bak files were moved to another folder.

    If you are using SSMS to generate the restore statement or to run the restore SSMS only knows where the .bak files were written.  If they were moved you will need to edit the script to point to the proper location for both files.  SSMS does not know anything about someone moving files around.  (Nor does it know if someone deleted the files.)

    For a lengthy discussion of "the media set has 2 families" problems, there is this long thread which includes comments from Tibor, who was the first responder to this thread.

    http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/abf50e00-c9b0-4809-9e61-43ed8a53e968/

    RLF