PrepAway - Latest Free Exam Questions & Answers

which Transact-SQL statement should you use?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. You set the recovery model of the Finance database to Full. Every day at 2:00 a full database backup of all the user databases is performed. Every 15 minutes the transaction log backup is performed while A differential backup is performed every 4 hours. You intend to perform a full backup of the Funds database at 11:00. You must ensure that when you perform the backup, the overall backup and restore procedures for the Funds database will not be affected. Besides this, you have to ensure that the backup files are restored in proper sequence. So which Transact-SQL statement should you use?

PrepAway - Latest Free Exam Questions & Answers

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;

One Comment on “which Transact-SQL statement should you use?


Leave a Reply