Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.

The SQL Server 2008 R2 instance contains a database named ABC_DB. ABC_DB stores its data
file and transaction log file on a storage drive.
When it is reported that the storage drive is reaching capacity, you are instructed to relocate the
data file and transaction log file to a different storage drive.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.

The SQL Server 2008 R2 instance contains a database named ABC_DB. ABC_DB stores its data
file and transaction log file on a storage drive.
When it is reported that the storage drive is reaching capacity, you are instructed to relocate the
data file and transaction log file to a different storage drive.
Which of the following actions should you take?

A.
You should consider making use of the sp_attach_db Transact-SQL statement.

B.
You should consider making use of the CREATE DATABASE Transact-SQL statement.

C.
You should consider making use of the sp_detach_db Transact-SQL statement.

D.
You should consider making use of the ALTER DATABASE Transact-SQL statement.

Explanation:



Leave a Reply 0

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