You administer a Microsoft SQL Server 2012 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?

Question

Options

• AIn SQL Server Management Studio, right-click the instance and select Database Settings.
• BIn SQL Server Management Studio, right-click the database, select Properties, and then click Files.
• CUse the ALTER DATABASE...SET LOGFILE command along with the midsize parameter.
• DIn SQL Server Management Studio, expand the Storage leaf under the database.

• A
  8% (2)
• B
  83% (20)
• C
  4% (1)
• D
  4% (1)

No community discussion yet for this question.