Cant Attach Back Up File

• najeeb_kt2000

  Old Hand

  Points: 398

  More actions

  July 28, 2012 at 3:42 am

  #264899

  Trying to repair database from Backup file giving errors .

  Restore failed for Server 'USER-PC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

  The backup set holds a backup of a database other than the existing 'FLEX'

  I am using the backup of the same daabse tried many metods. All failed

  Server error messages as follows.

  Restore failed for Server 'USER-PC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

  at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)

  at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()

  System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'FLEX' database. (Microsoft.SqlServer.Express.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

  at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)

  at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)

  at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 28, 2012 at 5:03 am

  #1518858

  RESTORE ... WITH REPLACE

  Just check that the backup does contain what you think it does (restore headeronly) as that message means exactly what it says.

  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

• Vikrant S Patil

  SSCrazy

  Points: 2294

  More actions

  July 28, 2012 at 9:12 am

  #1518880

  and in addition to restore headeronly you can also execute "restore filelistonly" to get a list of the database and log files that are contained in the backup set from which you are trying to restore.

  Also discussion from the following URL may prove useful for you ( they are suggesting the same as what Gail suggested, namely the REPLACE option)

  http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/4f17d722-5c4a-4730-a2cf-1507b6e6be17

  http://msdn.microsoft.com/en-us/library/aa238217(v=sql.80).aspx

  http://blog.sqlauthority.com/2007/09/27/sql-server-fix-error-3154-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-database/[/url]