What should you do?

You administer a Microsoft SQL Server database. You need to ensure that the size of the transaction log file does not exceed 2 GB.

What should you do?
A . Execute sp_configure ‘max log size’, 2
C . Use the ALTER DATABASE…MODIFY FILE command along with the name and maxsize parameters.
D . Use the ALTER DATABASE…MODIFY FILEGROUP command along with the name and maxsize parameters.
E . Use the ALTER DATABASE…AUTO_SHRINK command along with the On parameter.

View Answer

Answer: B

Explanation:

MODIFY FILE specifies the file that should be modified. The file could be a log file.

MAXSIZE { max_size| UNLIMITED } specifies the maximum file size to which the file can grow.

References: https://technet.microsoft.com/en-us/library/bb522469(v=sql.105).aspx