Back to the list Mastering SQL Server · Trunk Road

Lesson 2/6 SQL Server: options, restore, logs and monitoring

Name: SQL Server: options, restore, logs and monitoring
Uploaded: 2025-07-06
Description: Restore a database, set the server options and keep an eye on the logs day to day.

Administering SQL Server once it is installed. Memory and authentication settings. Managing Active Directory users and roles. Database Mail and SMTP notifications. Activity Monitor for spotting expensive queries. A full restore with full, differential and log backups.