You are managing a SQL Server 2008 instance which includes a database called TesterDB
for Home.com. The data file and the transaction log file which are located on the D: drive
that owns only 10 percent useful space. You should make sure that you move both files to
the G: drive.
Which is the correct answer?
A.
You should implement the statement below: ALTER DATABASE Finance SET
RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and
B.
Run the following Transact-SQL statements. ALTER DATABASE Finance MODIFY
FILE(NAME = Finance_Data, FILENAME =
C.
mdf’); ALTER DATABASE Finance SET MULTI_USER;
D.
You should utilize the following Transact-SQL statement.
E.
ALTER DATABASE TesterDB SET OFFLINE WITH ROLLBACK_IMMEDIATE;
F.
ALTER DATABASE TesterDB
G.
mdf’); ldf’); ALTER DATABASE TesterDB SET ONLINE;