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

• JBentrum

  SSC Enthusiast

  Points: 113

  More actions

  September 20, 2020 at 5:19 pm

  #3789707

  I'm trying to restore a database from our production server to my local machine using the following script but still get the error, 'The backup set holds a backup of a database other than the existing 'MyDB' database.

  USE [master]

  RESTORE DATABASE [MyDB]

  FROM DISK = 'C:\MyDB.bak'

  WITH

  REPLACE,

  MOVE 'MyDB' TO 'C:\MyDB.mdf',

  MOVE 'MyDB_log.ldf'

  GO'

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  September 21, 2020 at 7:52 am

  #3789743

  The command is somewhat incomplete, it is missing the correct syntax near move for the log file.

  It should be something more like this

  USE [master]
  RESTORE DATABASE [MyDB]
  FROM DISK = 'C:\MyDB.bak'
  WITH
  REPLACE,
  MOVE 'MyDB' TO 'C:\MyDB.mdf',
  MOVE 'MyDB_Log' TO 'C:\MyDB_log.ldf'
  GO

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  September 21, 2020 at 1:29 pm

  #3789795

  It is possible though that the backup has more than one database inside of it. You can query the file to find out if there's an issue.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning