Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. You set recovery model full. You run a full database backup for the whole the
user databases at 01:00 hours everyday. The transaction log backup happens each 20 minutes.
You could run a differential backup each 5 hours. You decide to run a full backup of the Products
database at 12:00 hours. Not only you should make sure that you could run the backup without
affecting the overall backup and restore procedures for the Products database but also you could
restore the Backup files in proper sequence. Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. You set recovery model full. You run a full database backup for the whole the
user databases at 01:00 hours everyday. The transaction log backup happens each 20 minutes.
You could run a differential backup each 5 hours. You decide to run a full backup of the Products
database at 12:00 hours. Not only you should make sure that you could run the backup without
affecting the overall backup and restore procedures for the Products database but also you could
restore the Backup files in proper sequence. Which is the correct answer?

A.
You should use the codes below:
bak ‘ WITH NOUNLOAD;

B.
You should use the codes below:
bak’ WITH COPY_ONLY;

C.
You should use the codes below:
trn’ WITH DIFFERENTIAL;



Leave a Reply 0

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