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?

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?

A.
You should consider cutting down the number of times between transaction log backups for the database.

B.
You should consider cutting the SQL sentences down in size in order to make the smallest value for the database.

C.
You should consider setting the database to use the simple recovery model for the database.

D.
You should consider using the DBCC SHRINKFILE statement towards the transaction log file for the database.



Leave a Reply 0

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