Microsoft
70-432 · Question #133
You maintain a SQL Server 2008 instance that contains a database named Finance. The data file and the transaction log file are located on the E: drive. The E: drive has only 5 percent available…
The correct answer is B. Run the following Transact-SQL statement. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance that contains a database named Finance. The data file and the transaction log file are located on the E: drive. The E: drive has only 5 percent available space. You need to move both files to the V: drive. Which procedure should you use?
Options
- ARun the following Transact-SQL statement.
- BRun the following Transact-SQL statement.
- CStop the SQL Server service.
- DStop the SQL Server Service.
How the community answered
(16 responses)- A6% (1)
- B75% (12)
- C13% (2)
- D6% (1)
Community Discussion
No community discussion yet for this question.