Wednesday, February 27, 2013

SQL Server 2012 Administration, Backup, Recovery and Tuning

You will learn how to configure SQLServer 2012 tools and service accounts, Database diagrams and Availability options.

SQL Server 2012 Configuration Manager

SQL Server 2012 Service Accounts

SQL Server 2012 Database Diagrams

Automating SQL Server 2012

SQL Server Agent Introduction

Configuring SQL Server Agent

Multiserver Administration in SQL Server

Availability Options in SQL Server

History of Microsoft SQL Server

Using MMC Snap-Ins in SQL Server

Backup and Restore of SQL Server Databases and Maintenance plans
The SQL Server backup and restore component provides an essential safeguard for protecting your business critical data in the databases. The below Videos will help to understand the backing up SQL Server databases, backup and restore strategies.

Understanding Recovery Models in SQL Server

Backup and Recovery Planning in SQL Server

Performing Backups and Restores in SQL Server

Using the Maintenance Plan Wizard in SQL Server

Using Maintenance Plan Design in SQL Server

How to Import database in SQL Server 2012

SQLServer Database Tuning and Server MonitoringSQL Server provides a comprehensive set of tools to monitor Database engine, events in the SQL Server and for tuning the physical database.

You will learn monitoring SQLServer and tuning.

What to Monitor in SQL Server

Database Engine Tuning Advisor in SQL Server

Monitoring Basics in SQL Server

Monitoring Events in SQL Server

Dedicated Administrator Connection in SQL Server

Using System Monitor in SQL Server

Satishbabu Gunukula


  1. I think it is very effective post for us. Thanks for this nice and Helpful post. There is exciting moderately nice about the "SQL Server 2012 Administration, Backup, Recovery and Tuning". I like the suggestion.
    I think, This is largely because hard drives are complex devices and their technological specifics are not generally well known.
    I want to share some Information about data recovery.

  2. I'm really enjoying the design and layout of your site. It's a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Superb work! st index