You got an alert that says a user database log file is growing and it reached 85%. How do you handle the situation?

Started by Emanuel, April 24, 2016, 06:45:02 AM

Previous topic - Next topic

Saif

Hello, I would like to submit a question that puzzles me, you got an alert that says a user database log file is growing and it reached 85%. how do you handle the situation? Please give me your help.

Zack

With this method, you can restore your database at Point of Time if a disaster ever happens at your server.

Let us run an example to demonstrate this. In this case, I have done the following steps:

Create Sample Database in FULL RECOVERY Model
Take Full Backup (full backup is must for taking subsequent backup)
Repeat Following Operation
Take Log Backup
Insert Some rows
Check the size of Log File
Clean Up