LEARN. CONNECT. EXPLORE
Search catalog

PL21627 - Vault Preventative SQL Maintenance – Maintaining a healthy database

Class speakers
Session description

If looking to improve the general health of your Vault SQL Server implementation, improve performance, or automate backups, this course is for you. It’s geared towards Vault administrators looking to improve maintenance in their SQL Server environments using SQL Server Maintenance Plans. As maintenance plans are not something that is installed or implemented with out of the box solutions from Autodesk or Microsoft, we will provide a suggested solution for use with SQL Server. We will cover the basics of implementing a SQL Server maintenance plan to keep Autodesk Vault SQL Server Databases running at their most optimum levels, hourly, daily, weekly, monthly and beyond. Users will have a base maintenance plan to get started and will walk away with the knowledge to modify that plan to suit their own unique environments. This session features Vault Professional, Vault Basic, and Vault Workgroup.

Additional information
Understand what a maintenance plan is and why they are needed
Create a maintenance plan that can be utilized in any environment
Know at a high level the intricacies of the maintenance plan (understanding/options)
Adjust the maintenance plan as needed for each business unit/organization (customization)
Intermediate
SQL Server, basics
PLM and Data Management
Vault Workgroup, Vault Professional, Vault Basic
General Manufacturing and Product Design
Process Manufacturing
Vault administrators and CAD Managers looking to ensure database health in their relevant systems and gain knowledge related to SQL Server database maintenance.
None
Instructional demo
Collaboration, Intellectual Property, Product Lifecycle Management, Product Manufacturing
Vault Workflows for Power Users
Beyond software basics
Instructional demo
1 hour
Share to Facebook Share to Facebook Share to Facebook Share to Facebook Share to Facebook
Class schedule
    Register now
    © Copyright 2016 Autodesk, Inc. All rights reserved. Legal Notices & TrademarksPrivacy
    No
    Yes
    View more
    View less
    Working...
    Close
    OK
    Cancel
    Confirm
    System message
    Delete
    Schedule
    An unknown error has occurred and your request could not be completed. Please contact support.
    Scheduled
    Wait listed
    Personal calendar
    Speaking
    Conference event
    Meeting
    Meal
    Interest
    This class or activity cannot be scheduled.
    Conflict found
    This class is already scheduled at another time. Would you like to...
    Loading...
    Please enter a maximum of {0} characters.
    {0} remaining of {1} character maximum.
    Please enter a maximum of {0} words.
    {0} remaining of {1} word maximum.
    must be 50 characters or less.
    must be 40 characters or less.
    Class summary