Friday, October 19, 2012

SQL SERVER - How you maintain production database in daily basic

 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 completed.
  • See to Job History / Log file Viewer
  • See to Job Activity Monitor
  • Check the database size.
  • Current transaction
  • Error log and Agent error log.

Like and Share to SQL Integrity Blog

No comments:

Post a Comment

Thank You !!!!