How to install agent and backup SQL Server Database in Commvault V11 SP18?

Video Summary

The video provides a detailed tutorial on installing the SQL Server agent and backing up SQL Server databases using Commvault V11 SP18. Key points from the video include:

• Installation Process
  • The speaker refers to a previous video about creating a custom package for SQL Server, which will be used for agent installation.
  • The custom package is designed for ease of use, allowing even those with limited knowledge of Commvault to install it.
  • The installation process is automated, including registration, configuration, and communication with the Commvault console.
• SQL Management Studio Settings
  • The video discusses the importance of configuring user roles in SQL Management Studio for backup operations.
  • Users can choose to use a system user or provide specific credentials for backups.
• Commvault console Configuration
  • After installation, the SQL Server agent appears in the Commvault console.
  • The speaker demonstrates how to configure backup settings, including the use of VSS (Volume Shadow Copy Service) for backing up databases in use.
• Backup and Restore Options
  • The video explains how to initiate backups, monitor job statuses, and view completion percentages.
  • It covers options for restoring databases, including restoring to different locations and advanced restore features, such as table-level restores.
• Monitoring and Management
  • The speaker emphasizes the importance of monitoring backup jobs through the job controller in the Commvault console.
  • Users can check the status of backups and any failures that may occur.
• User Interaction
  • The speaker encourages viewers to like, subscribe, and provide feedback or requests for future video content.

Main Speakers/Sources

• The video features a single speaker who provides hands-on guidance throughout the installation and backup process.