Webinar Originally aired on April 25, 2013
Most DBA’s know you need to be doing some form of maintenance on your databases: backups, index rebuilding\reorganization, update statistics, integrity checks, and system cleanup. SQL Server offers some basic tasks to complete this needed maintenance. The session will cover setting up a maintenance plan including the tasks, schedules, and logging. From there, we will dive deeper into the basic task, find out what is going on behind the scene, and discuss when it is ok to use them and when you should create your own. At the end of the session you will know how to create a maintenance plan, how to log results and keep a history of success or failures, when you should use what SQL Server has provided and when you should create your own plan.
This presentation has been presented at SQLSaturday #183, Rocky Mountain User Group Training days 2013, and Denver SQL Server User Group.
Our presenter, Kathleen Meadows, has been working with SQL Server since 1998 starting with SQL Server 6.5 up to the latest and greatest. Over the years, Kat has worked in many different environments from manufacturing to dotcoms to military and government institutions, and is now back in the private sector. Currently, as a Senior DBA at XTIVIA, she is focused on monitoring SQL Server installations and troubleshooting performance issues. Kat is also the President of the Colorado Springs SQL Server User Group. She possesses a Bachelor's degree in Managing Information Systems from Colorado Technical University.
Auf dieser Seite können Sie das Online-Video SQL Server Maintenance Plans mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer XTIVIA Technical Resources 17 Januar 2019 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 867 Mal angesehen und es wurde von 2 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!