Author Topic: You got an alert that says a user database log file is growing and it reached 85%. How do you handle the situation?  (Read 349 times)

Offline Saif

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
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.
« Last Edit: December 09, 2017, 05:47:30 PM by Sofyene »



Offline Zack

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Database log file
« Reply #1 on: December 09, 2017, 05:52:03 PM »
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


 

Sitemap 1 2 3 4 5 6 7 8 9