Error 3101

Severity Level 16

Message Text

Database in use. The system administrator must have exclusive use of the database to run the restore operation.

Explanation

This error occurs when you attempt to load a database backup while users are accessing the database. You cannot use the RESTORE DATABASE statement while the database is in use by any user, including yourself.

Action

Wait until all users have finished using the database, and then use the RESTORE DATABASE statement. Make sure that you are not in the database being loaded when you issue the RESTORE DATABASE command. Although not required, it is best to run the RESTORE DATABASE statement from the master database.

See Also