Microsoft
70-432 · Question #115
70-432 Question #115: Real Exam Question with Answer & Explanation
The correct answer is C. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH COPY_ONLY:. See the full explanation below for the reasoning.
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;
Community Discussion
No community discussion yet for this question.