You administer a Microsoft SQL Server server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService.
You plan to configure Instant File Initialization.
You need to ensure that Data File Autogrow operations use Instant File Initialization.
What should you do? Choose all that apply.
A. Restart the SQL Server Agent Service.
B. Disable snapshot isolation.
C. Restart the SQL Server Service.
D. Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy.
E. Add the CONTOSO\SQLService account to the Server Operators fixed server role.
F. Enable snapshot isolation.
You administer a Microsoft SQL Server server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService. Yo
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You administer a Microsoft SQL Server server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService. Yo
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!