Post reply

Error during restore sql 2005 backup to sql 2008

  • February 19, 2011 at 2:40 am

    #245884

    I AM GETTING THE FOLLOWING ERROR WHILE RESTORING SQL 2005 BACK UP TO SQL 2008

    BACKUP IS TAKEN IN A SINGLE FILE ONLY.

    Restore failed for Server 'VIRENDER-PC'. (Microsoft.SqlServer.SmoExtended)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

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

    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)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&LinkId=20476

    [font="Arial Narrow"]Failure is not the worst thing. The worst Thing is not to try[/font]

  • February 19, 2011 at 4:11 am

    #1289168

    When you took the backup, you striped it across two files, not one. If the backup was taken from management studio and there were two files listed in the backup destination, the backup went to both, not the selected one.

    To restore this you need both backup files.

    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

  • February 19, 2011 at 6:35 am

    #1289176

    on the source server, run the following script to find out where your back files are:

    select database_name,backup_start_date,physical_device_name

    from msdb.dbo.backupset bs

    inner join

    msdb.dbo.backupmediafamily bmf

    on bs.media_set_id = bmf.media_set_id

    where database_name = <your db name>

    order by backup_start_date desc

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

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