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’, 2G.
B. Use the ALTER DATABASE…MODIFY FILE command along with the name and maxsize parameters.
C. Use the ALTER DATABASE…MODIFY FILEGROUP command along with the name and maxsize parameters.
D. Use the ALTER DATABASE…AUTO_SHRINK command along with the On parameter.
