You are the administrator of a SQL Server 2000 computer. The server contains a database na
The database files are configured as shown in the database properties exhibit.
The database developers have been creating new tables and indexes without specifying a filegroup.
The primary filegroup is reaching its maximum capacity.
You want the developers to continue adding new objects, but you do not want then to change the way they create objects. You do not want to run out of disk space. You also want to minimize the time it takes to administer the database.
What should you do?
A.Back up the existing objects on the PRIMARY filegroup. Drop them from the database. Re-create them on the SECONDARY filegroup.
B.Set the file growth on the PRIMARY filegroup to UNLIMITED.
C.Set the PRIMARY filegroup so that it is read-only.
D.Set the SECONDARY filegroup as the default filegroup.