Restoring a Database

Administration > SQL Server Administration > Administration Tasks > Database Administration > Restoring a Database

You can restore a database by using one of the following tools:

• Model Explorer

See Restoring a database (Model Explorer).

• ScfUtils command line interface

See Restoring a database through ScfUtils (Model Explorer).

• Model Manager

• SQL Server Management Studio

If the database you are trying to restore exists in SQL Server, you may have to perform the following tasks:

• Delete the database.

• Use the Optimize command in Model Explorer to truncate the database log.

• Close Model Explorer, and make sure not to select the database from the list before running the Restore command.

For more information about restoring a database, refer to the following SQL Server Management Studio help topic:

Restore a Database Backup (SQL Server Management Studio)

https://docs.microsoft.com/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-2014

The Restore command should be performed on the machine that is hosting the SQL Server instance. The restore command in Model Explorer and Model Manager is disabled if the Integrity Modeler server is not local.

If you are using a remote machine to create a backup through ScfUtils, you should specify a UNC path for the backup file location. Local paths are relative to the Integrity Modeler server, and not the remote machine.