Microsoft
70-433 · Question #47
You are the administrator of a SQL Server 2008 instance with a database named DB1. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1…
The correct answer is B. BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1. Which Transact-SQL statement should you use?
Options
- ABACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak';
- BBACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION;
- CBACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL;
- DBACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION,
How the community answered
(22 responses)- A5% (1)
- B77% (17)
- C14% (3)
- D5% (1)
Community Discussion
No community discussion yet for this question.