Sql-server – how i can restore the back up file

backupsql server

I try to restore my .bak file using ms SQL server .but i keep getting this error…

Restore failed for Server 'CST-BLACKSERVER'. (Microsoft.SqlServer.Smo)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The backup set holds a backup of a database other than the existing 'fitness' database.
RESTORE DATABASE is terminating abnormally. (.Net SqlClient Data Provider)

Best Answer

Try this:

  • Select the Backup to restore
  • Set the Option "Override existing Database (WITH REPLACE)
Related Topic