VISUAL Focus 2019

Have you ever wondered what it takes to administer a SQL server for Visual Manufacturing? In this session you will learn how to ensure a SQL server running Visual is configured and maintained properly, and how to ensure backups are occurring on a regular basis, as well as a few other tips and tricks in SQL. We'll review how to use the Maintenance Plan Wizard in SQL to setup an appropriate plan. Ensure the database settings are correct for your desired method of backing up the database, review how to shrink stubborn transaction log files, setup server alerts from SQL server, and some simple ways to troubleshoot your setup. This is intended for intermediate-skilled IT folks that may not be familiar with SQL or SQL Server Management Studio, but could be attended by anyone that wants to learn some details about SQL server management in a Visual ERP environment.