Which database option should you turn on?

You maintain a SQL Server 2008 instance that contains a database named Finance.
You suspect that three large tables in the Finance database are corrupt. You plan to execute
the DBCC CHECKTABLE statement concurrently on the three tables to minimize downtime.
You need to set the database option to prevent users from accessing the database during
the execution of the statement.
Which database option should you turn on?

You maintain a SQL Server 2008 instance that contains a database named Finance.
You suspect that three large tables in the Finance database are corrupt. You plan to execute
the DBCC CHECKTABLE statement concurrently on the three tables to minimize downtime.
You need to set the database option to prevent users from accessing the database during
the execution of the statement.
Which database option should you turn on?

A.
OFFLINE

B.
READ_ONLY

C.
RESTRICTED_USER

D.
SINGLE_USER



Leave a Reply 0

Your email address will not be published. Required fields are marked *