Can u get me the answer to this question
Management wants the backups to be done daily. Transaction log backups must be
every afternoon and morning and that you should keep in mind that the content of the log will get
larger and larger. You also need to take measure to do the log file.
What should I do?
A. You should consider cutting the number of time between transaction log backups for the
B. You should consider cutting the SQL sentences in order to make the smallest value for the
C. You should consider setting the database to use the simple recovery model for the database.
D. You should consider cutting the DBCC SHRINKFILE towards the transaction log file for the
pls let me know the answer and get the resourse from where i could get
the detailted knowledge abt the topic.As m new .
May 6, 2010 6:21 AM
May 7, 2010 5:30 AM