To reimport a backup, use the following restore procedures. To restore databases, you need the same authorizations as for the backup.
To reimport a backup, activate the relevant function by selecting Tools, then Database Utilities, then Restore SQL Database. Remember that the function only works with SQL Server/MSDE if it is installed on the same computer as Microsoft Access. When you are importing the data backup, no other users can work on the database.
This section describes the most important settings and options available in Enterprise Manager for restoring databases.
To activate the data restore function, select the database to be restored from the ...