You manage an instance of SQL Server 2008. You want to be able to back up and restore the SQL Serverinstance by using the Volume Shadow Copy Service (VSS) framework. Which service should you enable to provide this functionality?
A.
the SQL Writer service
B.
the SQL Server service
C.
the SQL Server Agent service
D.
the SQL Server Integration service
Explanation:
You should enable the SQL Writer service because this service provides the functionality for backing up andrestoring SQL Server through the VSS framework. The SQL Writer service is installed when you install SQLServer, but it is not enabled by default. You must enable this service because this service is required by the VSSapplication to perform a backup or restore. You should not enable the SQL Server service, SQL Server Agent service, or SQL Server Integration servicebecause none of these services provide the functionality for backing up and restoring SQL Server through theVSS framework. The SQL Server service is responsible for providing storage, processing, and controlled accessof data, and rapid transaction processing. The SQL Server Agent service is responsible for executing jobs,monitoring SQL Server, and triggering alerts. The SQL Server Integration service is responsible for providingmanagement support for SQL Server Integration Services (SSIS) package storage and execution.
Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Configure SQL Server services.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Managingthe Database Engine Services > SQL Writer Service