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: