You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Staff. The Full Recovery Model is implemented for the CK_Staff database.
Domain.com acquires another company named TestLabs.com. You import staff data from the new company into the CK_Staff database. Soon after ward you notice that Certkiller -DB01 is performing quite poorly. You discover that the transaction logs for the CK_Staff database has increased by almost five times in size and has consumed most of the free disk space. You need to recover disk space as soon as possible.
What should you do?
A.
Backup the transaction log files.
B.
Switch to the Simple Recovery Model.
C.
Run the DBCC SHRINKFILE Transact-SQL statement.
D.
Truncate the transaction log files.
Explanation:
TheDBCC SHRINKFILE statement is used to reduce the log files to a specified size.
Incorrect Answers:
A: Backing up the log file clears the log file but does not reduce the physical size of the transaction log file.
B: Switching to the Simple Recovery Model will not reduce the physical size of the transaction log file.
D: Truncation reduces the logical size of the transaction log file but it does not reduce the physical size of the transaction log file.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: DBCC SHRINKFILE statement
Microsoft SQL Server 2005 Books Online (2006), Index: transaction log backups [SQL Server]