You are trying to restore a database using the SQL Management Studio but receive an error message stating that the database is in use. You did tell the users to stop using the database temporarily…

The correct answer is B. Use the Activity Monitor and kill connections to the database you are restoring. In this scenario its best to kill the connections as long as the users have been warned that they should not be using the database. Even if you wait, sometimes connections can stay in the

Design an optimized high availability and disaster recovery solution

Question

You are trying to restore a database using the SQL Management Studio but receive an error message stating that the database is in use. You did tell the users to stop using the database temporarily. Which of the following should you do to correct this?

Options

ADo nothing, wait 30 seconds for the locks to timeout on users connections
BUse the Activity Monitor and kill connections to the database you are restoring
CUse the Restrict access to the restored database option
DTheres nothing you can do but wait for all users to stop using the database

How the community answered

(56 responses)

A
18% (10)
B
71% (40)
C
7% (4)
D
4% (2)

Explanation

In this scenario its best to kill the connections as long as the users have been warned that they should not be using the database. Even if you wait, sometimes connections can stay in the

Topics

#database restore#Activity Monitor#connection management#kill sessions

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice