Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


Database maintenance is an ongoing task for SQL Server 2012 administrators. This requires the integrity of the database to be checked, the database size to be kept to a minimum by ensuring the files are the correct sizes, and maintenance tasks to be run regularly. SQL Server 2012 Transact-SQL provides DBCC, which is a command that provides statements to maintain the database and database files. An administrator can also create jobs using SQL Server Agent to automate administrative tasks in the SQL Server Database Engine and throughout the enterprise by having the jobs run on multiple SQL Server servers throughout the enterprise using a master server. SQL Server 2012 provides the Database Mail feature which allows e-mails to be sent from SQL Server to users through applications. These e-mails can be anything from alerts to query results and files from any network resource using SMTP. This course demonstrates how to confirm the integrity of a database and manage the size of the database files. It also demonstrates how to configure Database Mail and SQL Server Agent jobs for a single server and for multiple servers. This course also discusses the database architecture and how to create and configure a database. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Learning Objectives
  • Recognize how to perform database management tasks using the DBCC CHECKDB command
  • Alter the size of a database
  • Describe the features of Database Mail
  • Use the Database Mail Configuration Wizard to configure Database Mail
  • Manage a SQL Server 2012 database
  • Configure and manage Database Mail
  • Identify the steps to configure SQL Server Agent to automate SQL Server administration
  • Create a SQL Server Agent job
  • Describe the characteristics of automated server administration in SQL Server 2012
  • Set up servers to facilitate administrative job automation
  • Recognize how to manage SQL Server Agent Jobs
  • Recognize how to manage target servers
  • Use SQL Server Agent to automate SQL Server administration
  • Manage servers and jobs
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.