in logshippig restore the data into instance server HA error came plz help any body

• venkyindus

  SSC Rookie

  Points: 37

  More actions

  June 22, 2012 at 2:36 am

  #260379

  TITLE: Microsoft SQL Server Management Studio

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

  Restore failed for Server 'VENKAT-PC\HA'. (Microsoft.SqlServer.SmoExtended)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&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.1600.1+((KJ_RTM).100402-1539+)&LinkId=20476

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

  BUTTONS:

  OK

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

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  June 22, 2012 at 5:45 am

  #1504444

  is this the restore of the initial full backup?

  sounds like you have a striped backup and you need to supply all the files in the backup set to the restore command

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