Restore database which is in use

You need to kick all the users out, and make sure you're not in that database too. Assuming you're in Management Studio, you need to change your context to a different database or switch the database dropdown to a different database this way, and this will also kick out any other users which could be you - Object Explorer, Object Explorer Details, other query windows, etc.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 4 months ago. Active 1 year, 2 months ago. Viewed 41k times.

Restore failed. Smo "System. This is a comment on StackOverflow. Usually, the full error message is like this. Restored failed for Server Additional Information: System. SqlError: Exclusive access could not be obtained because the database is in use. Any version of SQL Server, when this kind of problem occurs, can benefit from the provided solutions here.

It's possible to restart the Server service as the StackOverflow user does, but do not take it as the first step regarding the data safety.

Next, we advise users to go through the four procedures to rectify the problem. While restoring a database, you need to disconnect all the users using the option to close connections when you restore a database. So, it is good to first check the active users and notify them before disconnecting. So, by restarting the SQL server, you can disconnect all the users connected to the server.

But, use it only as the last option when all other methods do not work. Using the single-user mode by switching from multiple-user mode can disconnect all the users connected to the server. However, this approach should be followed only when you want to disconnect the users without notifying them.

The tools can be used to recover data from corrupted backup, repair a corrupted SQL database file. Many SQL Server Database Administrators DBAs struggle repeatedly with errors like abrupt termination, database connection or transient errors, problem with drivers, malicious software attack, etc. Such errors can render a database unusable. While rebooting the SQL server may resolve the problem in some cases, using a backup.

Step 4: Right-click the Database , and then click Restore Database. Step 5: The Restore Database window is displayed.

From the General page, under Source section, select any of these options:. Choose the Database option, and then select the database you want to restore from the drop-down list. Choose the Device option, and then click the ellipses Step 6: The name of the database to be restored is displayed in the Database box under Destination section.

And, information of the selected backup file will be added in the Backup sets to restore section.