Post reply

Error in Restore SQL2000 .BAK in a SQL2005

  • November 16, 2007 at 5:04 am

    #126993

    I have a Client that send to me a sql 2000 database in a .bak file (his SQL Server is a SQL 2000).

    When I try to restore this backup in my sql server 2005 I get the following error:

    "TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Restore failed for Server 'MCORAIS'. (Microsoft.SqlServer.Smo)

    ------------------------------

    ADDITIONAL INFORMATION:

    System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)

    ------------------------------

    Can anyone help me?

  • November 16, 2007 at 5:18 am

    #751782

    The database has been backed up into two files, you need both to restore the database. First make sure that the customer sends you both files, and then make sure you specify both of them in Management Studio.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • November 16, 2007 at 12:34 pm

    #751955

    Andras is correct. What happened is the customer had two files specified in the backup dialog and ended up with a "striped" backup, with both files containing part of the backup.

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

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