Use Interactive SQL to restore a database from an archive backup.
You do not have any incremental backups of the transaction log that need to be applied as part of the recovery process.
If you created the backup of a strongly-encrypted database with free page elimination turned on, specify the encryption key for the database when restoring it.
The following statement restores a database from a tape archive to the database file C:\newdb\newdb.db.
RESTORE DATABASE 'c:\\newdb\\newdb.db' FROM '\\\\.\\tape0';
The following statement restores a database from an archive backup in file C:\backup\archive.1 to the database file C:\newdb\newdb.db. The transaction log name and location are specified in the database.
RESTORE DATABASE 'c:\\newdb\\newdb.db' FROM 'c:\\backup\\archive';
The following statement restores a database from an archive backup in file C:\backup\archive.1 to the database file C:\newdb\newdb.db. The transaction log name and location are specified in the database. The encryption key is specified for the database.
RESTORE DATABASE 'c:\\newdb\\newdb.db' FROM 'c:\\backup\\archive' KEY '3Km57y1z';