How to maintain production database in daily basic. There are some basic steps, we can check/ consider / follow to it, To maintain the SQL database-
Is all database is online or not
- Typically, I check and verify
scheduled to database backup.
- All jobs run successfully and
- See to Job History / Log file Viewer
- See to Job Activity Monitor
- Check the database size.
- Current transaction
- Error log and Agent error log.