Restore SQL Server database

• 1 use master
  go
  
• 2 RESTORE DATABASE DatabaseName FROM DISK='c:\MSSQL\Backup\DatabaseName.bak' WITH REPLACE;
  
• N DatabaseName will be created.
  

References

• https://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/