BACKUP in SQL SERVER

Tags:
SQL Server backup
SQL Server logs
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Fhhdjfhjdhfjhjdfh
    Thnx sir , For replying with the detailed answer to the question It added to my konwledge for SQL server .
    135 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following