SQL INDONESIA

As a production DBA, I wanted to make sure all production sql servers are backup properly.
And it’s amazing to me that when I assigned to Audit production Microsoft SQL Servers environment. I found many production databases did not have a properly backup plans as show below:

Even the database backup is known by many. Un-fortune, one did not appreciate that how important database backups when databases failed or disaster.

So, I started implementing the backup and recovery plan like:

• Setup and Created an operator
• Setup database mail.
• Full Back up is scheduled to run on Sunday
• Differential Backup is scheduled to run from Monday through Saturday
• Log Backup is scheduled to run a daily every hour
• Added Alerts notifications