Best Practices for SQL Server Maintenance


MSSQLTips sponsored on-demand webinar

Webcast Abstract

Proper maintenance of a SQL Server requires several steps that need to run in harmony. From backups, corruption checks, index maintenance, data archiving, pruning system tables -- along with all the different options available -- it can be overwhelming!

This session will explain what types of things need to be done such as:

  • backups and backup options
  • index maintenance
  • integrity checks
  • shrinking files
  • reviewing SQL and OS logs
  • reviewing maintenance report files
  • monitoring and alerting of these tasks
  • troubleshooting
  • and automation
We will cover the steps to what should be done along with suggested best practices. We will cover a few different methods to implement these processes along with some advice for what order and how often to perform them. Equally important, it will cover some steps that should NOT be taken despite what some of the wizards might tell you.

Whether you are new to SQL Server or just looking for a refresher, this session is for you.

Speaker - Eric Blinn

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.




download











get free sql tips
agree to terms