1.

You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur._x005F_x000D_ - A BULK INSERT job imports data at 10:00 P.M- Indexes are rebuilt at 10:15 P.M- Data integrity checks are performed at 10:30 P.M- A differential backup is performed at 10:45 P.M- A DBCC SHRINKDATABASE job runs at 11:00 P.M._x005F_x000D_ You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file  'inventory_data'."You need to ensure that the final job runs without errors._x005F_x000D_ What should you do?

A. Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually.
B. Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.
C. Increase the time between the differential backup and the DBCC SHRINKDATABASE job.
D. Increase the time between the data integrity checks and the differential backup.
Answer» D. Increase the time between the data integrity checks and the differential backup.


Discussion

No Comment Found

Related MCQs