70-432 · Question #115
You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance. The recovery model of the Finance database is set to Full. A full database backup of all the…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #115. The question stem and answer options stay visible for context.
Question
You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance. The recovery model of the Finance database is set to Full. A full database backup of all the user databases is performed at 02:00 hours daily. The transaction log backup occurs every 15 minutes. A differential backup is performed every 4 hours. You plan to perform a full backup of the Finance database at 11:00 hours. You need to ensure that the backup is performed without affecting the overall backup and restore procedures for the Finance database. You also need to ensure that the backup files are restored in proper sequence. Which Transact-SQL statement should you use?
Options
- ABACKUP LOG FINANCE TO DISK = 't:\backups\finance.trn';
- BBACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH NOUNLOAD;
- CBACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH COPY_ONLY:
- DBACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH DIFFERENTIAL;
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.