Which Transact-SQL statement should you use?

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?

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?

A.
BACKUP LOG FINANCE TO DISK = ‘t:\backups\finance.trn’;

B.
BACKUP DATABASE FINANCE TO DISK = ‘t:\backups\finance.bak’ WITH NOUNLOAD;

C.
BACKUP DATABASE FINANCE TO DISK = ‘t:\backups\finance.bak` WITH
COPY_ONLY:

D.
BACKUP DATABASE FINANCE TO DISK = ‘t:\backups\finance.bak` WITH
DIFFERENTIAL;



Leave a Reply 0

Your email address will not be published. Required fields are marked *