BACKUP in SQL SERVER
Hello Sir,
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
database.
B. You should consider cutting the SQL sentences 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 cutting the DBCC SHRINKFILE towards the transaction log file for the
database.
pls let me know the answer and get the resourse from where i could get
the detailted knowledge abt the topic.As m new .
Thnx.
Software/Hardware used:
SQL SERVER
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
database.
B. You should consider cutting the SQL sentences 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 cutting the DBCC SHRINKFILE towards the transaction log file for the
database.
pls let me know the answer and get the resourse from where i could get
the detailted knowledge abt the topic.As m new .
Thnx.
Software/Hardware used:
SQL SERVER
ASKED:
May 6, 2010 6:21 AM
UPDATED:
May 7, 2010 5:30 AM
Answer Wiki:
Ah, test questions got to love them.
A. Reducing the amount of time between log backups will reduce the size that the log grows.
B. You always want the smallest transaction size (I'm assuming that is what you are talking about here) do reduce database locking. Reducing transaction size won't reduce the size of the transaction log though.
C. Only use the SIMPLE recovery mode if you don't want point in time restore. As you need to do transaction log backups you can't use SIMPLE recovery mode.
D. Never ever use DBCC ShrinkFile unless you really, really need to. There is no acceptable reason to schedule DBCC SHRINKFILE to run on a regular basis. All running DBCC SHRINKFILE will do is cause file fragmentation on the physical disks and the VLFs within the log.
To see all answers submitted to the Answer Wiki: View Answer History.
Thnx sir ,
For replying with the detailed answer to the question
It added to my konwledge for SQL server .