Can not restore SQL 2008 database because the database is in use.

Question

Hello! I can't restore SQL database when someone uses it. I have an error during restore:

avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Exclusive access could not be obtained because the database is in use.

It is pretty common thing when you are restoring database and it is useable in the moment. Usually there is an option to take database in a single user mode during the restoration, but I can't find something like this in Avamar. I use Avamar 7.0.0-427.

Please, help me with this issue.

DELL-Leo · Answer

Hey, Please refer to CHAPTER 4 Restore of Avamar 7.0 for SQL Server. Hope this can help to you!

pawankumawat · Answer

Hello,

There is an KB article which describes this issue and its resolution.

https://emc--c.na5.visual.force.com/apex/KB_BreakFix_1?id=kA1700000000VFc

Please go through this KB article. Hope this will help you.

Regards,

Pawan

Avamar

Can not restore SQL 2008 database because the database is in use.

Was this post helpful?