You are responsible for managing a SQL Server 2005 database. This database is updated with data that is exported from another site. On a monthly basis, data is loaded into the database from a flat file by using the bcp utility.
This operation should be minimally logged. However, users report that they receive error messages indicating that the transaction log is full.
You investigate and discover that the errors occur when the data is being imported.
You need to prevent this problem from occurring. What should you do?
A.
Disable the clustered index and all nonclustered indexes on the target table.
B.
Set the database recovery model to full.
C.
Set the database recovery model to bulk-logged.
D.
Use the BULK INSERT statementto load the data.