Microsoft
70-432 · Question #141
You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #141. The question stem and answer options stay visible for context.
Question
You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which Transact-SQL statement should you use?
Options
- ABACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak*;
- BBACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH COMPRESSION:
- CBACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH DIFFERENTIAL:
- DBACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION-
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.