You are responsible for managing a SQL Server 2008 computer. The server contains several databases thatcontain mission-critical information.
You configure daily backups for all databases. To ensure that the backupprocess takes less time, you want to configure backup compression on the server.
Which fixed server role or roles will allow you to perform this task? (Choose all that apply.)
A.
dbcreator
B.
sysadmin
C.
serveradmin
D.
setupadmin
E.
securityadmin
Explanation:
The sysadmin and serveradmin fixed server roles will allow you to perform the task. Backup compression is anew feature introduced in SQL Server 2008 Enterprise Edition. A compressed backup is smaller than anuncompressed backup of the same data. Therefore, compressed backups require significantly less time thanuncompressed backups. Compressed backups are useful when you want to move backups from one instance ofSQL Server to another, such as in log shipping. After configuring log shipping, it is good practice to compresstransaction log backups so that they consume less space and transfer more quickly to secondary databases onseparate SQL Server 2008 instances. To ensure that all new backups are compressed by default, you canconfigure the backup compression default option by using SQL Server Management Studio. To perform thistask, you must be a member of the sysadmin or serveradmin fixed server role. You can also configure backupcompression using the sp_configure system stored procedure. The dbcreator , setupadmin , and securityadmin fixed server roles do not allow you to configure the backupcompression default option on the SQL server. The dbcreator fixed server role allows its members to create,modify, drop, and restore any database on the server. The setupadmin fixed server role allows its members toadd and remove linked servers. The securityadmin fixed server role allows its members to manage logins andtheir properties.
Objective:
Performing Data Management TasksSub-Objective:
Implement data compression.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administration: How-to Topics > Server Management How-to Topics > Server Configuration How-to Topics > Howto: View or Change the backup compression default Option (SQL Server Management Studio) TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > BackingUp and Restoring Databases in SQL Server > Backup Overview > Backup Compression (SQL Server)