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 !!!!