Problems Restoring SQL Server Databases


When trying to restore a SQL Server database, you may get an error that states the backup is for a different database or that the database is in use. The quickest way to get around this is to take the database offline to close all open connections, put it back online, and then restore the database with the REPLACE option ticked on the Options tab of the Restore Database dialog.

Advertisements