You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
During monitoring you notice that one of the computers that have the data files is not working.
However, you need to reserve the database which is from the most recent
configurations of backups as soon as possible.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. The backup of CK_DB is as follows:
* Full backup at 13:00
* Differential backup at 15:00
* Database snapshots at 20:00 and 21:00

Furthermore, the backups and the database snapshots are reserved on a different disk. However,
CK_DB has failed at 18:30. You have received instruction to recover CK_DB with the minimal
amount of data loss.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1.
The backup method of CK_DB1 is follows:
* Full backup, Sunday at 01:00
* Differential backup, weekdays at 22:00
* Transaction log backup weekdays at 08:00; 12:00 and 16:00

You have received notification that the user database data files have failed on Wednesday at
17:00. You need to ensure that CK_DB1 are saved with the minimal amount of data loss.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using SQL Server 2005
Enterprise Edition. You need to get the information on the torn page errors of the database.
However, you need to get a solution on the torn page errors.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using SQL Server 2008
Enterprise Edition. Domain.com contains a database that unfortunately has torn page errors.
You need to solve the problem of the torn page errors.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The backup of CK_Prod is as follows:
* Full backup at 01:00 daily
* Transaction log backup every 20 minutes
* Differential backup every 5 hours

However, you need to do a full backup of CK_Prod at 12:00. You need to make sure that the
backup would not affect the overall backup and restore procedures for CK_Prod and that you can
restore the Backup files in correct sequence.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB.
CK_DB have 100 GB information where 2 GB of the information is changed daily.
CK_DB has its recovery model set for Simple.
However, Domain.com states that data loss of more than three hours worth of transactions during business
hours is a NO – NO. You need to ensure to use a backup strategy will use the least number of disk
spaces and still complies with Domain.com.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. You have received instructions from
management to cut the content of the entire database backup files of CK_DB.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Management wants the backups to be done on a daily basis. Transaction log
backups must be every afternoon and morning and thus you should keep in mind that the content
of the log will grow exponentially resulting in a large transaction log file that needs to be backed up.
You thus received instructions to take appropriate measures when doing the backups of the transaction log files.

What should you do?